Posted on

• ERD Exercises
You are required to create ERDs for the following exercises and submit (or show to your prac supervisor) them to get marked off for this week’s prac activity

  1. Given the following business rules, create the appropriate Crow’s Foot ERD.
  • A company operates many departments
  • Each department employs one or more employees
  • Each of the employees may or may not have one or more dependents.
  • Each employee may or may not have an employment history.
  1. Use the following business rules to create a Crow’s Foot ERD. Present all appropriate connectivities and cardinalities in the ERD.
  • A department employs many employees, but each employee is employed by one department.
  • Some employees are not assigned to any department.
  • A division operates many departments, but each department is operated by 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 managed by only one employee.
  • One of the employees runs each division, and each division is run by only one employee.
    Hint: More than one relationship may be existing between two entities.

Prac 2
• ERD Exercises
Note: For the following exercises you are required to create a completed version of models by creating necessary attributes for each entity (while the last prac exercises required to list a couple of essential attributes only).

As each exercise is for you to design a full version of ERD (though the business rules here are a lot simpler than real-world situations), you will need to carefully design all components of your model considering the business rules provided. Such consideration may include deciding about “what attributes are included in each entity?”, “Should the relationship be 1:1, 1:M or M:N?”, “Should the relationship be identifying or non-identifying?” “Should the relationship on one entity side be optional or mandatory?” etc.

You are recommended to start drawing your draft ERD on the paper firstly before creating the more confirmed ERD using MySQL Workbench or other drawing tools.

  1. Use the following business rules to create a Crow’s Foot ERD. Present all appropriate connectivities and cardinalities in the ERD.
  • A department employs many employees, but each employee is employed by one department.
  • Some employees are not assigned to any department.
  • A division operates many departments, but each department is operated by 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 managed by only one employee.
  • One of the employees runs each division, and each division is run by only one employee.

Hint: More than one relationship may be existing between two entities.

  1. Create an ERD based on the Crow’s Foot model, 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), which describe the products bought by the customer.
  • The product information is stored in a PRODUCT entity.
  • The product’s vendor information is found in a VENDOR entity.
  1. Create a Crow’s Foot ERD, using the following business Rules.
  • A Team may or may not have a Player
  • A Player must belong to a Team
  • A Team may have many Players
  • A Player has only one Team
  • A Team may or may not have a Coach
  • A Coach must have a Team
  • A Team may have many Coaches
  • A Coach has only one Team
  • A Player must have a Parent
  • A Parent must have a Player
  • A Player may have up to 2 Parents

Pages: 5 Double spaced (1375 words)
Style and sources: APA7, 1 sources
Free extras: Bibliography/ Reference page
Study level: Bachelor
Assignment type: Essay
Subject: Mathematics and Statistics
Language: Us