Advance Database

DATABASE DESIGN PROJECT

DELUXE DEPARTMENT STORE

Please prepare PowerPoint slides in order to present your solutions to DELUXE

The Deluxe 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) store managers do the following (use the charts given):

A) Logical Design
1. range and name distributively entity.
2.For for each one entity, disclose and name each attribute.
3.Identify the primary key for each 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 quantify 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 need to interact with each supplier. I can rival to each supplier by their name even though several suppliers have the same name. Therefore, its a good intimacy that each supplier has a unique supplier way out that can go from 1 to 1000. Of course, I need to last 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 want to get a full essay, order it on our website: Orderessay



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