CIS 336 - Introduction to Database - iLab 2

The attachment has all relevant information. I saw another answer posted for this but it didn't seem complete, not using all entities and attributes. I'd also prefer if any diagrams were done in Visio but its not a must.

 

Deliverables

The deliverable for this lab will be your completed ERD as a single MS Word document using copy/paste or imported as an image from your drawing/modelling application, cropped and sized appropriately (it should fit on a single page), and named lab2_solutions_yourname.

LAB STEPS

STEP 1: Drawing Entities and Attributes

Back to Top

Be sure to include all of the entities that have been defined. You need to include at least the primary and foreign key attributes where applicable in your diagram.

STEP 2: Add Relationships

Back to Top

Be sure that you link all entities based on PK to FK relationships. There may be a case where you need to identify a combination PK and if so make sure that all of the relationships involved are defined. Be sure that you have set your drawing/modelling tool set to show Crow's Foot notation. Also, be sure that you are defining the correct cardinality for the relationships.

STEP 3: Naming of relationships

Back to Top

If your drawing/modelling tool creates a default name for relationships, do not simply accept this default without due consideration. There may be some relationships where the default is applicable, but in most cases you will want to explicitly name the relationship. Be sure that you have provided a verb phrase for both directions in the relationship.

• 1500641305-CIS336 Lab2_Instructions 1.docx

APlusGrades

Not Rated (0)

Status NEW Posted 21 Jul 2017 12:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer