i am having a very hard time understand how to format the 1 to 1 relationship between products and purchase numbers along with any questions to do with a disk. the tables are my own.
also not sure if my entity relationship diagram makes sense. please help
Purchase Name Credit # no. product price date 34523447 02/09/201 James Brown 81254.1 Blue cell phone cover $24.95 7 34523447 12/09/201 James Brown 81254.2 touch screen clear overlay $14.95 7 34523447 27/09/201 James Brown 6. 81254.3 cell phone car adapter $35.00 7 44533497 05/09/201 Linda Foster red tablet case 82368.1 $45.95 7 44533497 10/09/201 Linda Foster 82368.2 cell phone car adapter $35.00 7. 44533497 19/09/201 Linda Foster 84250.1 touch screen clear overlay $14.95 7 Cameron 88644523 23/09/201 black leather notebook Packer $95.00 7 63565.1 case A) Explain why your above table would not be a good way of organizing data on disk. B) Convert the unnormalized sales table (file) to a relational database design. Fill each database table in your design with data from the question such that no information is lost. Identify the data fields, primary key, foreign key, and combination keys. Describe why it is better to store data on a disk in this way rather than all in one table. C) Create an Entity relationship diagram Notes: The owner would like to use the customer credit number as a way of locating each customer in the system. Purchase numbers have a 1-to-1 relationship with products. ULJUUIA J.3J A4532497 10n0/201 Fo. er en on cat dag $3, 0 unnormalized table. Purchase no. Name Credit # product 81254.1 Blue cell phone cover 81254.2 touch screen clear overlay 81254.3 cell phone car adapter 82368.1red tablet case 82368.2cell phone car adapter 84250.1 touch screen clear overlay 63565.1 black leather notebook case date $24.95J02/09/2017 $14.95 12/09/2017 $35.00 27/09/2017 $45.95 05/09/2017 $35.00 10/09/2017 $14.95 19/09/2017 $95.00 23/09/2017 price James Brown 345234476 James Brown 345234476 James Brown 345234476 Linda Foster 445334978 Linda Foster Linda Foster 445334978 445334978 |Cameron Packer 886445234 Version lof Customer +tot relationship (product or table by credit # Product Serial product 81254.1 Blue cell phone cover 81254.2 touch screen clear overlay 81254.3 cell phone car adapter 82368.1 red tablet case Purchase no. Name Credit 345234476 James Brown 445334978 Linda Foster 886445234 Cameron Packer 82368.2 cell phone car adapter 84250.1 touch screen clear overlay 63565.1 black leather notebook case each customer transaction ocured on a # business day Purchase no. Product 81254.1 Bell cell phone cover 81254.2 touch screen clear overlay 81254.3 cell phone car adapter 82368.1 red tablet case 82368.2 cell phone car adapter 84250.1 touch screen clear overlay 63565.1 black leather notebook case Credit price date $24.95 02/09/2017 $14.95 12/09/2017 $35.00 27/09/2017 $45.95 05/09/2017 $35.00 10/09/2017 $14.95 19/09/2017 $95.00 23/09/2017 345234476 345234476 345234476 445334978 445334978 445334978 886445234 Credit Number C) Entity Relationship Diagram Identifies Customer Name Requests Contains Product Order - Occurs Date O : Entity or = Relation ship Develops Purchase Number
