functional dependency in database Design normalized data model, computer science homework help

User Generated

wbuayrrbx7

Computer Science

Description

21. A pet store currently uses a legacy flat file system to store all of its information. The owner of the store, Peter Corona, wants to implement a Web-enabled database application. This would enable branch stores to enter data regarding inventory levels, ordering, and so on. Presently, the data for inventory and sales tracking are stored in one file that has the following format: StoreName, PetName, Pet Description, Price, Cost, SupplierName, ShippingTime, QuantityOnHand, DateOfLastDelivery, DateOfLastPurchase, DeliveryDate1, DeliveryDate2, DeliveryDate3, DeliveryDate4, PurchaseDate1, PurchaseDate2, PurchaseDate3, PurchaseDate4, LastCustomerName, CustomerName1, CustomerName2, CustomerName3, CustomerName4 Assume that you want to track all purchase and inventory data, such as who bought the fish, the date that it was purchased, the date that it was delivered, and so on. The present file format allows only the tracking of the last purchase and delivery as well as four prior purchases and deliveries. You can assume that a type of fish is supplied by one supplier. Show all functional dependencies. What normal form is this table in? Design a normalized data model for these data. Show that it is in 3NF. 22. For Problem and Exercise 21, draw the ER diagram based on the normalized relations.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hello here is the assignment.

ER diagram of the normalized relations
Normalization:
This is a process used to minimize data redundancy and dependency in a relational
database. This is because having redundant data and more null values increases the
storage space and wastage of memory is imminent
.Entity relationship is basically a picture about the business system that is the information
stored, created is represented by the diagram. With a good knowledge of the ERD I can
find the needs of...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags