Create an erd based on the crows foot notation

Assignment Help Computer Engineering

Reference no: EM132158084

Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

• A department employs many employees, but each employee is employed by only one department.

• Some employees, known as "rovers," are not assigned to any department.

• A division operates many departments, but each department is operated by only one division.

• An employee may be assigned many projects, and a project may have many employees assigned to it.

• A project must have at least one employee assigned to it.

• One of the employees manages each department, and each department is man- aged by only one employee.

• One of the employees runs each division, and each division is run by only one employee.

Create an ERD based on the Crow's Foot notation using the following requirements:

• An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative.

• The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices.

• An INVOICE can include many detail lines (LINE), each of which describes one product bought by the customer.

• The product information is stored in a PRODUCT entity.

• The product's vendor information is found in a VENDOR entity.

Reference no: EM132158084

Questions Cloud

Low levels of the amino acid isoleucine : Imagine that the low levels of the amino acid isoleucine are associated with an increased risk of osteoporosis. Further imagine that calcium supplements

Proteins with a single transmembrane segment : Suppose you obtain a novel dietary supplement in an liquor store. According to the label, this supplement increases the mobility (within the membrane) of protei

Write out the genotypes of the male and female parents : Write out the genotypes of the male and female parents and their F1 male and female offspring.

Technology and describe it briefly indicating its uses : Choose one technology and describe it briefly indicating its uses.

Create an erd based on the crows foot notation : Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

Meiotic nondisjunction in female eggs : The age of the father has little or no effect. What do you think are possible reasons leading to this meiotic nondisjunction in female eggs?

Scientific differences between rna and dna : What are some scientific differences between RNA and DNA?

Determine the noise power : Determine the noise power (in dBm) at 27o C in a 7 MHz bandwidth?

In the lab about the effect of enzyme and temperature : In the lab about the effect of enzyme and temperature, Why the temperature increases, the volume of oxygen increase?

User Account

All Pages