Advance Database

DATABASE DESIGN PROJECT DELUXE DEPARTMENT STORE enjoy prep be PowerPoint slides in order to present your solutions to DELUXE The gold Department Store compulsions to render its record keeping. You have been engage to perform the logical and forcible database design. After reading the interviews of the future(a) line managers do the following (use the charts given): A) Logical institution 1. range and relate distributively entity. 2.For for apiece one entity, disclose and detect for apiece one attribute. 3.Identify the primary key for apiece entity. 4.What is the domain of values for each attribute? 5.What are the dependencies among attributes of each entity? 6.What are the relationships between 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 transactions. 11.Identify the access of each transaction (update/read). 12.What is the frequency (# of evaluate per day, per week, per month). 13.Identify the entities and relationships in each transaction. 14.For each transaction, is it batch or on-line. 15.

Which entities are accessed by each transaction and how often? B) physiologic Design 1.Draw an enterprise description. 2.Draw the physical tables and indicate where indices should go. INTERVIEWS BUYER I am a buyer for the deluxe department store. I drive to interact with each supplier. I can rival to each supplier by their name even t hough some(prenominal) suppliers have the s! ame name. Therefore, its a good intimacy that each supplier has a unique supplier way give away that can go from 1 to 1000. Of course, I need to make it their address and phone numbers. Since many suppliers supply similar items, I need to know the price of each item by supplier. For instance a red pen from supplier 1 might cost 2 dollars and 3 dollars from supplier 2....If you deficiency to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay