Lab_05_AM10-13 - 7.104 DATABASE ENG INEER ING I WEEK 05...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 7.104 DATABASE ENG INEER ING I WEEK 05 AM10-13 LAB / TUT DATA MODEL ING WIT H T HE ENT I TY RE LAT IONSH IP 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. I t 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 Crows 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 1 | P a g e (B) Using Crows 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 | P a g e 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 studentsA student enrols in many classes....
View Full 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 / 6

Lab_05_AM10-13 - 7.104 DATABASE ENG INEER ING I WEEK 05...

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