Convert the e-r diagram below into the relations

Assignment Help Database Management System

Reference no: EM131502568

Assignment : E-R and Database Assignment

Instruction:

1. Draw an E-R Diagram.

Draw an E-R diagram based on the description below (Use the notation learned in the lecture).

A Database is being constructed to keep track of data about UNB students' status of job applications. A student can apply to more than one company and a company has many students who applied to the company. The UNB also keeps track of an advisor who helps each student to practice for job interviews.

Each student is assigned to only one advisor and each advisor helps at least one student. For each student, the database is to hold the students' ID (primary key), name, and an e-mail address. For each company, the database is to hold the company ID (primary key), name and address. For each advisor, the database is to hold the tutor ID (primary key), and a telephone number.

2. Convert the E-R diagram below into the corresponding relations (tables). Show the primary keys and other fields in the relation. Underline the primary keys, dotted underline the foreign key, and use arrows to indicate the foreign keys and the corresponding primary keys. (20%)

1328_ER diagram.jpg

Reference no: EM131502568

Questions Cloud

Describe a use case dependency for making an account deposit : Describe a use case dependency for making an account deposit. Illustrate this use case with Visio or a similar product.

Differences between risk treatment-risk avoidance : Contrast and compare the differences between Risk Treatment, Risk Avoidance, Risk Mitigation, Risk Acceptance, and Risk Transfer?

Evaluate the accuracy of diagnostic and procedural coding : Evaluate the accuracy of diagnostic and procedural coding. Evaluate, implement and manage electronic applications/system for clinical classification and coding.

What are the main components of a generic router : What are the main components of a generic router? Give a brief explanation of each component.

Convert the e-r diagram below into the relations : Draw an E-R diagram based on the description below.Convert the E-R diagram below into the corresponding relations (tables).

Compile this task as per the assignment requirements : Provide a query for The Sales Manager asks you to provide the average Pretax Sales amount throughout the years.

Security and privacy implications of the hitech act : Falls Health System consists of four hospitals and six healthcare clinics that cover three rural counties.

Formats for creating and watching movies : In recent times, HD-DVD and Blu-ray were competing technology formats for creating and watching movies on DVDs.

Create a set of invariants for attribute and relationship : Create a set of invariants for attribute and relationship and add them to the CRC cards for each class in the structural model using Object Constraint Language.

User Account

All Pages