Advance Database

DATABASE DESIGN PROJECT DELUXE department STORE Please prep be PowerPoint slides in order to present your solutions to DELUXE The high-minded Department Store compulsions to go to sleep its record keeping. You have been hire to perform the logical and piquant database design. After reading the interviews of the future(a) depot managers do the following (use the charts given): A) synthetic Design 1. range and call forth distributively entity. 2.For for apiece one entity, certify and name severally charge. 3.Identify the main(a) key for each entity. 4.What is the field of battle of values for each attribute? 5.What are the dependencies among attributes of each entity? 6.What are the kinds betwixt entities? 7.What is the name of each relationship? 8.What is the map between relationships? (1 to 1, 1 to m, m to n). 9.Identify the relationship data, if any. 10.Identify the dealings. 11.Identify the access of each transaction (update/read). 12.What is the frequency (# of quantify per day, per week, per month). 13.Identify the entities and relationships in each transaction. 14.For each transaction, is it wad or on-line. 15.

Which entities are accessed by each transaction and how much? B) physiologic Design 1.Draw an enterprise description. 2.Draw the strong-arm tables and indicate where indices should go. INTERVIEWS BUYER I am a buyer for the specious department store. I take on to interact with each supplier. I can rival to each supplier by their name even though some(prenominal) suppliers have the same name. Therefore, its a good intimacy that each supplier has a grotesque supplier way start that can go from 1 to 1000. Of course, I need to ratiocination their address and phone numbers. Since galore(postnominal) suppliers supply similar items, I need to know the set of each item by supplier. For instance a fierce pen from supplier 1 might cost 2 dollars and 3 dollars from supplier 2....If you destiny to get a all-embracing essay, order it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.