IDS410 Fall 2017-a poss Home Wok 1- Home Sweet Home Diagram ble solution Manoper

Question

IDS410 Fall 2017-a poss Home Wok 1- Home Sweet Home Diagram ble solution Manoper Grp Member Localomice PK GrouDNO StantDate Car Allowance MonthlyBonus Area SSN JobTite Job Ttle Salary PA Typing Speed Street State Interviews Registers Relationship Is Relatad to PK ClientNo Name InterviewDate InspoctDato PK OwnerNo row 3 City State Comments Comments Name Phone OwnerType PK RentalNo Phone Max Rent Pret type PaymentMe StartDate EndDate City State PK PropertyNo NewsPaper Area Street PK NowsName PK IsPaid iewDate Street City State [Duration zp Type RentAmnt ISForRent Fnone Contact PK AdNo PropNotroRent PK AdDate AdDetail Cost WithdrawDate E For rant N ContactName BusinessType

Explanation / Answer

LocalOffice(LocalOfficeNo,Area,Street,City,Zip,Phone,Fax)

Employees(EmployeeNo,Name,SSN,JobTitle,JoinedDate,Salary,Gender,Phone,Street,City,State,Zip)

Client(ClientNo,Name,Street,City,State,Zip,Phone,Max_Rent,Pref_Type)

Interview(EmployeeNo,ClientNo,InterviewDate,Comments)

Viewing(ClientNo,PropertyNo,ViewDate,Comments)

PropNotForRent(PropertyNo,WithdrawDate)

Rental(RentalNo,Rent,PaymentMe,STartDate,EndDate,Deposit,Ispaid,Duration)

Property(PropertyNo,Area,Street,City,State,Zip,Rooms,Type,RentAmount,IsForRent)

Advertisement(AdNo,AdDate,AdDetail,Cost)

NewsPaper(Newsname,Street,City,State,Zip,Phone,Contact)

BusinessOwner(OwnerNo,ContactName,BusinessType)

Owner(ownerNo,Name,Phone,OwnerType,Street,City,State,Zip)

NextOk(EmployeeNo,name,Street,City,State,Zip,Phone,Relationship)

Grp_Member(GroupNo,EmployeeNo)

AdminGrp(GroupNo,GroupName)

Manager(EmployeeNo,LocalOfficeNo,StartDate,Car-Allowance,MonthlyBonus)

PA(EmployeeNo,TypingSpeed)

Inspection(EmployeeNo,PropertyNo,InspectDate,Comments)

underlined attributes are primary keys and italicised are foreign keys . Some attributes are both.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---