ZuoTi.Pro
Question

ERD requirements: In your ERD*, you must include: • All entities and the relationships among them;...

ERD requirements: In your ERD*, you must include: • All entities and the relationships among them; • Reasonable attributes for each entity; • Notations of all PKs and FKs • Cardinalities for each relationship.

ERD Cases: Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have been told to use in the course.

A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee ID (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) and Start Date. Attributes of EQUIPMENT include Serial No and Cost. The organization wishes to record Assign Date—that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be assigned, and a given project need not be assigned either a chemist or an equipment item.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1


0 0
Add a comment
Know the answer?
Add Answer to:
ERD requirements: In your ERD*, you must include: • All entities and the relationships among them;...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 1. Please answer the following questions. You need to draw ER diagrams using any free tools...

    1. Please answer the following questions. You need to draw ER diagrams using any free tools discussed in the class or you may draw using pencil and paper. Please identify the entities and relationships between them. For each entity, please identify the attributes each entity has. For each attribute, please identify whether this attribute is optional or required, single valued or multi-valued, simple or composite, stored or derived. Define a key (identifier) for each entity. Note that a key can...

  • Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information,...

    Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by...

  • 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s),...

    1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or...

  • Instructions: You are required to create ERD and Enhanced ERD diagrams. And also translate your own...

    Instructions: You are required to create ERD and Enhanced ERD diagrams. And also translate your own created ERD & EERD diagrams in to Relational Model. Q# 1: Draw ER diagram based on the following database requirements. A Tutorial class may have one or more students. A student may be in one or more classes. Attributes of CLASS includes CLASS CODE, ROOM NAME and CLASS SIZE. Attributes of STUDENT include STUDENT ID, NAME and NATIONALITY. Translate your ER diagram in to...

  • Assignment 4 provides practice with applying the ERD notation to narrative problem descriptions. This assignment involves...

    Assignment 4 provides practice with applying the ERD notation to narrative problem descriptions. This assignment involves problems 20, 33, 34, 35, and 36 on Page 224 in the textbook (Chapter 6). Plan to use the drawing tool of your choice to create the ERD then copy and paste each ERD into a Word document. Label the problems in your Word document to match the problem in the textbook. Problems 33 to 36 are worth 15% each. Problem 20 is worth...

  • You will need draw a normalized entity relationship diagram (ERD) for the case described below. You...

    You will need draw a normalized entity relationship diagram (ERD) for the case described below. You only need to show your final ERD in 3NF. Case The North Carolina Division of Employment Security wants to build a system that tracks job seeking activity for unemployed individuals. When each individual applies for unemployment (referred to as an applicant) he/she is assigned a job coach who is responsible for monitoring the applicant’s job seeking activity. The development team has tentatively identified the...

  • Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based...

    Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based on everything listed below University Bookstore •University Bookstore has several branches throughout Bloomington, and employees may be assigned to work at any of the branches. •Employees are identified by an ID and have a full name, date of birth, SSN, address, multiple phone numbers, a gender, and a hire date. •A Manager runs a branch and is responsible for all operations at that branch....

  • Final Project: Part I For Part I of your final project, you will design your plan for the scenari...

    Final Project: Part I For Part I of your final project, you will design your plan for the scenario provided below. Your project plan should include the entity relationship diagram (ERD). Scenario Imagine that you just started a new job at ABC Car Sales. You’ve been given the task of adding all the new and used car inventory to a new database management system (DBMS). You would like to manage the new and used car sales in the new DBMS....

  • Create an Entity-Relationship Diagram (ERD). In the ERD include the following:

    Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...

  • Mr. Bob Dillon is a collector of china pieces. He needs a database is to store...

    Mr. Bob Dillon is a collector of china pieces. He needs a database is to store data about his collection. Each piece in this collection is to be identified by a unique ID value. Bob knows of several agents that work on getting these pieces shown in prestigious exhibitions. Each exhibition has an ID, a name, a venue, a start date and an end date. For all items shown, there is a deadline for returning them to the item owners....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT