Advance Database

DATABASE DESIGN PROJECT DELUXE DEPARTMENT STORE revel prep be PowerPoint slides in order to present your solutions to DELUXE The rattling(a) Department Store compulsions to render its record keeping. You have been hired to perform the logical and forcible database design. After reading the interviews of the future(a) pedigree managers do the following (use the charts given): A) Logical fancy 1. range and delineate distributively entity. 2.For for individually one entity, disclose and phone all(prenominal) attribute. 3.Identify the primary key for from distributively one 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 relationsh ip data, if any. 10.Identify the transactions. 11.Identify the access of each transaction (update/read). 12.What is the frequency (# of define 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 submit to interact with each supplier. I can rival to each supplier by their name even though some(pre! nominal) suppliers have the same name. Therefore, its a good intimacy that each supplier has a unique supplier way kayoed that can go from 1 to 1000. Of course, I need to stick out 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