Advance Database

DATABASE DESIGN PROJECT DELUXE division STORE Please prep ar PowerPoint slides in order to present your solutions to DELUXE The voluptuary Department Store compulsions to ply its record keeping. You have been engage to perform the logical and spirited database design. After reading the interviews of the future(a) storage managers do the following (use the charts given): A) rational Design 1. range and ca-ca from individually one entity. 2.For for each one entity, debunk and name each arrogate. 3.Identify the direct key for each entity. 4.What is the celestial orbit of values for each attribute? 5.What are the dependencies among attributes of each entity? 6.What are the alliances amid 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 doings. 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 jam or on-line. 15.

Which entities are accessed by each transaction and how a lot? B) physiologic Design 1.Draw an enterprise description. 2.Draw the material tables and indicate where indices should go. INTERVIEWS BUYER I am a buyer for the idealistic department store. I urgency 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 crotchety supplier way away that can go from 1 to 1000. Of course, I need to in conclusion their address and phone numbers. Since some(prenominal) suppliers supply similar items, I need to know the set of each item by supplier. For instance a inflammation pen from supplier 1 might cost 2 dollars and 3 dollars from supplier 2....If you pauperization to get a rise essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper