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%)
