DO EXERCISE 6 ONLY Developing Windows-Based and Web-Enabled Information Systems

Question

DO EXERCISE 6 ONLY

Developing Windows-Based and Web-Enabled Information Systems 106 model as follows. Is there any problem with this transformation? If so, discuss the problem(s) and make corrections. 5. The Buy relationship in the following E-R model is transformed into a relational Person Price Buy Type Member Customer ID Type TicketNo BuyDate Ticket TicketNo Price 6. Transform the E-R model in Exercise 5 to a relational model. 7. The transformation of an E-R model to a relational model is shown in the follow.- ing. Is this transformation correct? If not, explain what is incorrect and why it is incorrect, and make a correction. StudentName DateOfBirth Student Has Dependent

Explanation / Answer

Exercise 6: Relational Model

Person(ID,Name,Address,Phone,Email)

Employee(ID,DateOfHire,Salary)

EmployeeHistory(EmployeeID,EmHistory)

Customer(ID,Type)

Ticket(TicketNo,Price)

Buy(CustomerID,TicketNo,BuyDate)

Member(CustomerID,LoginName,Password)

underlined attributes are primary keys and italicised are foreign keys

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.