Design the conceptual schema using an er-diagram

Assignment Help Computer Engineering

Reference no: EM132178463

The Best Products Company is in need of a database to keep track of its Employees, Products, Departments, and Projects.

Assume that the requirements and analysis phase has been done and you are provided with the following descriptions of the needs:

The company is organized into departments which produce products, have employees, and control projects. Each department has a unique department number, name, location, and a particular employee that manage the department. The company keeps track of when the employee started managing the department.

Employees' records are stored. Information of interest to the company include: their ID number, address, sex, age, specialization, and telephone number.

An employee is assigned to one department based on their qualification but may work on several projects which are not necessarily controlled by the same department. The company then keeps track of the number of hours per week that an employee works for each project.

rojects must have a unique number, name, location, and the direct supervisor. Products records include product number, product name, date of manufacture, and unit price.

The company most of the time arrange products lists in alphabetical order by name. Products can be produced from several departments depending on the requirements. Products are classified according to the producing departments.

The company keeps track of whether or not employees drive to work for insurance purposes. The vehicles' records include registration number, body type, color, model, and age. At the end of each month the company produces a report on products produced and sold.

Required:

(a) Identify and list the items to keep track of in this company's database.

(b) Design the conceptual schema using an Entity Relationship Diagram (ERD) model for this company's database indicating the relationships, cardinality, and participation constraints. Explain all the reasoning behind the design.

(c) Map the ERD schema in (b) above to a Relational data model with sample data. Explain the mapping process from the ERD to the Relational model.

(d) Explain the normalization process that may be applied to this database in order to make it efficient.

Reference no: EM132178463

Questions Cloud

Determine the worst-case complexity of each : Determine the worst-case complexity of each of the following methods in terms of n and k.

What is expected value : If the four numbers come up in the order you picked, then you win $2500. What is your expected value?

Write statements to accomplish this : Write statements to accomplish this. First declare t with appropriate type, then use dynamic allocation more than once to create the entire array.

Find the expected value of owning a defibrillator : Suppose it costs $2,500 to buy a defibrillator. Find the expected value of owning a defibrillator if there is a 4% probability that Frontier Gym

Design the conceptual schema using an er-diagram : Design the conceptual schema using an Entity Relationship Diagram (ERD) model for this company's database indicating the relationships.

What is the probability that she gets fewer : A multiple-choice test consists of 7 questions. Each question has answer choices of a, b , c and d and only one of the choices is correct.

Higher on standardized test : A college professor claims that students who major I engineering in college score higher on standardized test than students who major ancient history.

Create a program to display a white sphere : The vtkSphereSource class generates a polygonal model of a sphere. create a program to display a white sphere.

What is the probability that a randomly selected student : What is the probability that a randomly selected student will get a starting salary of at least $5,000?

User Account

All Pages