Draw an eer diagram and their relationships

Assignment Help Management Information Sys

Reference no: EM132151525

Task 1

Draw an EER diagram that shows entities, a comprehensive list of attributes, relationships, and assumptions using MS Visio.

Apple stores would like to keep track of sales, product, and inventory information. Assume you have been asked to design a database to achieve this goal. Additionally, consider what potential sales reports an executive may want from this database and write one example of the report. Make any assumptions you deem necessary. Based on the given receipt, answer the following questions:

Task 2

Draw an EER diagram that shows entities, a comprehensive list of attributes, relationships, and assumptions using MS Visio.

1. List all possible entities and a comprehensive list of attributes for each entity.

2. Explain why you selected these entities.

3. Draw an EER diagram and their relationships. Make sure you pay attention to ERD notations and naming conventions.

4. Describe the report the sales executive may want to see. Make sure these additional entities and attributes are included in your diagram.

Reference no: EM132151525

Questions Cloud

Develop a use case context diagram for this system : You have been tasked with developing the software for an automated student loan system for use at universities.

New drug to reduce blood pressure : You test a new drug to reduce blood pressure. A group of 15 patients with high blood pressure report the following systolic pressures (measured in mm Hg):

Design a data structure to store the storm data : Once manufactured, rigorous testing for imperfections and documentation is an important part of the feedback loop to the next design cycle.

Random variable with mean 6 and standard deviation : Let X be the random variable with mean 10 and standard deviation 4 and Y be the random variable with mean 6 and standard deviation 2.

Draw an eer diagram and their relationships : Draw an EER diagram and their relationships. Make sure you pay attention to ERD notations and naming conventions.

Given that x is normally distributed : find the probability that X is less than 309.5, given that we know that X is larger than 288.4. State your answer rounded to 3 places of decimal.

Concepts of mutually exclusive events : What are the two basic rules of probability? Relate these rules to the concepts of mutually exclusive events and independent events.

What is the probability of drawing a club : One card is selected randomly from a standard 52-card deck. a. What is the probability of drawing a club?

Write a test program to test your class implementations : Write a program that defines a class Date and implement it as required. The class Date should consist of three private member variables.

User Account

All Pages