Lab_05_AM10-13 - Solution - 7.104 DATABASE ENGI NEER I NG I...

Info iconThis preview shows pages 1–9. 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

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 ENGI NEER I NG I WEEK 05 AM10-13 LAB / TUT SOLUT ION 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 2 | P a g e 3 | P a g e 4 | P a g e 5 | 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 6 | 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 students 4. A computer may require many services. The service may be required by many computers Part 2 1. A vendors invoice has at least one line item. The line item must belong to only one invoice. A line item will be for one part. Each part may be involved in many invoice line items 2. A part may be supplied by many vendors. Each vendor may supply many parts 3. Each part is composed of one or more parts. A part may be used by many products 4. Combine the entity models for Questions 1, 2, & 3 into one model 7 | P a g e SUBSCRIPTION SubNumber StartDate EndDate AmtDue LastName FirstName Address City State Zip PayCode SUBSCRIPTION is a weak, but not ID-dependent entity. Orders / Is Ordered By CUSTOMER CustomerNumber LastName FirstName Address City State Zip SUBSCRIPTION SubNumber StartDate EndDate AmtDue PayCode (C) Examine the subscription form below and use the structure of the form to do the followings; a. Create a model with one entity. Specify the identifier and attributeCreate a model with one entity....
View Full Document

Page1 / 15

Lab_05_AM10-13 - Solution - 7.104 DATABASE ENGI NEER I NG I...

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

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