DB Modelling Question-Solution

DB Modelling Question-Solution - Solution ERD: ERD...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Solution ERD: ERD – Conceptual Level COMPANY REPRESENTATIVE STUDENT EVENT STAFF CONTACT CONTACT_TYPE CONTACT_SUBJECT EMPLOYMENT PLACEMENT 1 1 1 1 1 1 1 1 1 m n n n n n n n n n n n n m m attends attends has involved in has has involved in attends has receives has receives
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ERD – Conceptual Level Assumptions: 1. Students can only commence employment with one company in a single day.
Background image of page 2
Relational Data Model (RDM) COMPANY (co_id, co_name, co_address1, co_address2, co_city, co_state, co_pcode, co_country) PRIMARY KEY (co_id) STUDENT (stu_no, stu_fname, Stu_lname, stu_comment) PRIMARY KEY (stu_no) STAFF (sta_id, sta_fname, sta_lname) PRIMARY KEY (sta_id) EVENT (ev_id, ev_date, ev_name, ev_comment) PRIMARY KEY (ev_id) EMPLOYMENT (stu_no, co_id, emp_date, emp_current, emp_comment) PRIMARY KEY (stu_no, emp_date) FOREIGN KEY (stu_no) REFERENCES student FOREIGN KEY (co_id) REFERENCES company PLACEMENT (stu_no, pl_fdate, pl_tdate, co_id, pl_comment) PRIMARY KEY (stu_no, pl_fdate) FOREIGN KEY (stu_no) REFERENCES student
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/15/2010 for the course MIT 424 taught by Professor Cevenini during the Three '10 term at Charles Sturt University.

Page1 / 4

DB Modelling Question-Solution - Solution ERD: ERD...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online