Whats the biggest difference between these two relational mo

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)

Solution

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