Whats the biggest difference between these two relational models and why? Catego

Question

Whats the biggest difference between these two relational models and why?

Category Product (categorylD, categoryName) (productlD, productName, productDescription, currentUnitPrice, inStock, season, categorylD) Customer (customerlD, firstName, lastName, streetNo, street, suburb, postcode, state, emailAddress) CustomerPhoneNo (customerlD, phoneNumber) Orders customerlD, phoneb omden ate Time, paymentStatus, streetNo, stree (orderlD, customerlD, orderDate Time, paymentStatus, streetNo, street, suburb, postcode, state) OrderContents Salesperson Partner (orderlD, productlD, productUnitPrice, productQuantity) (salespersonlD, firstName, lastName, phoneNumber, emailAddress, supervisorlD) (partnerlD, companyName, streetNo, street, suburb, postcode, firstName, lastName, phoneNumber, emailAddress, managerlD) Purchase (purchaselD, partnerlD, salespersonlD, productID, purchaseDateTime, paymentStatus, streetNo, street, suburb, postcode, state, productUnitPrice productQuantity, discount)

Explanation / Answer

The second relational model is a good database design than first one .

In contrast to first design second design has :

Mentioned primary and foreign key constraints

Applied all levels of normalization

No redundant data base tables.

Hence data integrity is maintained

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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