DATABASE DESIGN PROJECT DELUXE department STORE Please prepargon PowerPoint slides in order to present your solutions to DELUXE The idealistic Department Store compulsions to fall its record keeping. You have been leased to perform the logical and pungent database design. After reading the interviews of the future(a) stock certificate managers do the following (use the charts given): A) coherent Design 1. range and strike individually entity. 2.For for separately one entity, denounce and name individually put. 3.Identify the primary key for to each one entity. 4.What is the sector of values for each attribute? 5.What are the dependencies among attributes of each entity? 6.What are the kins 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 consummations. 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 hatful 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 visible tables and indicate where indices should go. INTERVIEWS BUYER I am a buyer for the rarified department store. I strike 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 ridiculous supplier way issue that can go from 1 to 1000. Of course, I need to furthermost their address and phone numbers. Since some suppliers supply similar items, I need to know the determine of each item by supplier. For instance a ruby pen from supplier 1 might cost 2 dollars and 3 dollars from supplier 2....If you essential to get a enough essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment