Lab_05_AM08 - 7.104 DATABASE ENGINEERING I WEEK 05 AM08 LAB...

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

View Full Document Right Arrow Icon
7.104 DATABASE ENGINEERING I WEEK 05 – AM08 LAB / TUT DATA MODELING WITH THE ENTITY RELATIONSHIP MODEL This laboratory / tutorial exercise aims for the student to understand and gain skills on how to design a database using entity relationship (e-r) model. It is recommended for students to follow the order as listed below; (A)The Tutor will demonstrate on how to draw a data model using MS Visio Format in IE Crow’s Foot Notations. Therefore, students will attempt to draw data models that presented in the Text Book Figure 5-16, 5-20, 5-22, 5-23, 5-30, 5-33, 5-37 and 5-52
Background image of page 1

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

View Full DocumentRight Arrow Icon
(B) Using Crow’s Foot Notations, draw in MS Visio Format the entity relationship diagram (ERD) after modelling each of the following cases; Part 1 1. Each company branch may have many vans. A van must be owned by only one branch 2. A vineyard must produce at least one wine label. Each wine label must belong to one vineyard 3. A student enrols in many classes. Each class may have many students
Background image of page 2
4. A computer may require many services. The service may be required by many
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 04/03/2011 for the course ECON 7.104 taught by Professor Wei during the Spring '11 term at Faculty of English Commerce Ain Shams University.

Page1 / 5

Lab_05_AM08 - 7.104 DATABASE ENGINEERING I WEEK 05 AM08 LAB...

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