HomeworkLib
Question

B) Using the scenario described by “A job assignment can be assigned to more than one...


B) Using the scenario described by “A job assignment can be assigned to more than one employee at a time; each employee can have only one job assignment”, work the following problems: 1. Identify each entity. 2. Identify each relationship type. Justify your answer. 3. Create the basic Crow's Foot ERD using Visio

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

Homework Answers

Answer #1

Q1: Identify each entity

Ans: JOB, EMPLOYEE

Q2. Identify each relationship type

Ans: the relationship between JOB and EMPLOYEE is 1:M

Q3: Create the basic Crow's Foot ERD using Visio

Ans:

Here || means a multiplicity of one.

0 0
Add a comment
Know the answer?
Add Answer to:
B) Using the scenario described by “A job assignment can be assigned to more than one...
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

  • Create a complete ERD for the problem described in problem ch team those cond Identif ....

    Create a complete ERD for the problem described in problem ch team those cond Identif . Identify . Identif . Identif PLAY . Draw . Draw Part 2 Design Concepts blems 1. 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...

  • can you show me how the crow foor ERD should be for this example 1. Given...

    can you show me how the crow foor ERD should be for this example 1. Given the following business rules, finish the business rule and create the appropriate Crow's Foot ERD. Paste the ERD from Visio into this document. a A COMPANY operates many DEPARTMENTS. b. Each DEPARTMENT employs one or more EMPLOYEEs. c. Each of the EMPLOYEEs might or might not have one or more DEPENDENTS. d. Each EMPLOYEE might or might not have an EMPLOYEE HISTORY Given the...

  • Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

    Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: In a small IT company, each assignment is related to performing a tech check up or working on a new project. All assignments share common attributes such as the assignment code and the description. In addition, unique attributes are used to describe each...

  • Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above,...

    Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above, work on the problems below: 1. For each table, identify the primary key. 2. For each table, identify the foreign key(s). 3. Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key. 4. For one of the tables, give examples of a superkey and a secondary key. 5....

  • PART I: E-R Diagram Using MS Visio, you have previously practiced creating E-R diagrams. In this ...

    PART I: E-R Diagram Using MS Visio, you have previously practiced creating E-R diagrams. In this exercise, you will read and understand a scenario, identify relevant entities, then create proper ER diagrams You are tasked with drawing an ER diagram for a database that contains companies, departments, employees, employees' dependents (children), and employees' history. Answer each of the following questions (a)-(e) by providing an ER diagranm (a) [10 points] Each company operates four departments, and each department belongs to one...

  • Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

    Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: A company owns three types of vehicles: cars, trucks, and motorcycles. When delivered, each vehicle goes through inspection. Each vehicle creates one record in the INSPECTION table. One record in the INSPECTION table is related to one vehicle. All vehicles share common basic...

  • Based on the description below, answer problems 7-8 Typically, a patient staying in a hospital receives...

    Based on the description below, answer problems 7-8 Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications, creating a 1:M relationship between ORDER and MEDICATION. 7. Identify the business rules for PATIENT, ORDER, and MEDICATION. 8. Create a Crow's Foot ERD that depicts a relational database model...

  • For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a...

    For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a many-to-many relationship between DeVry University students and their classes. Since one student can have many classes and each class can have many students, you will need to create an associative entity to store the specific Student_Class data such as grade and attendance. Create the tables as well as the relationships. Don't forget to indicate the Primary Key and Foreign Key in each table. Tables...

  • You are helping design part of an employee database for XYZ Inc, that links employees to...

    You are helping design part of an employee database for XYZ Inc, that links employees to their earned educational degrees and you are tasked with drawing the Entity Relationship Diagram (ERD) in Crow’s Foot notation. Entity: EMPLOYEE, EDUCATION, and BRIDGE. Business Rules: An employee can have one or more educational degrees (BS, MS, MBA, BA…) Each education degree is associated to one or more employees (more than one employee may have their MBA, BS…) This is a many-to-many relationship between...

  • I have created an ERD for the provided scenario, however I am having some trouble changing...

    I have created an ERD for the provided scenario, however I am having some trouble changing it into a Relational Model table, any help would be appreciated. The task is below, along with the ERD I came up with. Derive a Relational Model from the conceptual schema you provided in Task 1 (it should match exactly). For the purpose of this assignment, only derive the part of the database that stores the information about players, quests, beacons and treasures (considering...

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