Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following business rules to identify and write all attributes, relationships, and cardinalities between the entities shown on the next page. Do not add

Use the following business rules to identify and write all attributes, relationships, and cardinalities between the entities shown on the next page. Do not add any additional entities to the diagram. Decide which attributes should be primary keys and foreign keys for each entity and put those in the diagram. Remember to include relationship verbs for all relationships. Deliverable for this question: Please write the answers directly on the diagram on the next page. Take a picture of the diagram when you have finished and add the picture to the Word document created for Question 1. Do not turn in a separate file for your answer to each question. Application scenario: The application is for a research engineering company that needs to keep track of employees and equipment when they are assigned to a project. The database will be owned by the research engineering company. If you need to make assumptions about business rules other than the ones provided below, be sure to write those assumptions on your answer. An employee is uniquely identified by an EmployeeID. For each employee, the database should keep track of the FirstName, LastName, PhoneNumber, and EmailAddress. A project is uniquely identified by a ProjectID. For each project, the database should keep track of the ProjectMission and StartDate. A piece of equipment is uniquely identified by a SerialNumber. The database should keep track of the cost of the piece of equipment. An EquipmentType is uniquely identified by an EquipmentTypeID (as shown on the skeleton diagram). The database should keep track of the TypeDescription for each EquipmentType. Each piece of equipment is related to one and only one row in the EquipmentType entity, but a given row in the EquipmentType entity might be related to multiple pieces of equipment. The assignment entity is used to store the AssignDate and the ReleaseDate for the assignment of an employee to a project with a piece of equipment. The AssignmentID is the primary key. The assignment entity should be viewed as an intersection entity. An employee may be assigned to many different projects and pieces of equipment; A project may have many different employees and pieces of equipment assigned to it, and a piece of equipment may be assigned to many employees and projects. The assignment entity is used to store all the assignments.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MongoDB Applied Design Patterns Practical Use Cases With The Leading NoSQL Database

Authors: Rick Copeland

1st Edition

1449340040, 978-1449340049

More Books

Students also viewed these Databases questions

Question

8. Explain the relationship between communication and context.

Answered: 1 week ago