Alex Villanueva Create ERD Assignment 3
IS3280 Data Management
Assignment 3
Data Modeling and ER Diagrams
Review ER notation sets at http://adbc.kennesaw.edu Database Design ER Notations
Use how_to_draw_er_in_ppt.pptx or Gliffy to draw the models.
If you use Gliffy save your drawing as an image [jpg file] and insert it into a Word document (in fact just adding your images to this document would be a good idea).
Submit your word document if you used Gliffy or your powerpoint document via the D2L DropBox.
1. (2 pts) Examine the subscription form shown below. Using the structure of this form, do the following:
Create a model with two entities, one for customer and a second for subscription. Specify identifiers, attributes, relationships and cardinality
2. (2 pts) Draw the ERD for the following scenario. The only attribute you need to include is the IDENTIFIER. Be careful with your cardinality.
A patient has one or more patient histories; each instance of patient history belongs to one patient.
3. (2 pts) Draw the ERD for the following scenario. Include all the attributes. Note that one of your tables will have a composite identifier.
You want to maintain a list of your contacts. You retain the following information, lastname, firstname, address, city, state, zip code and phone numbers.
[Hint: note that the contacts can have multiple phone numbers – this is the classic multi-valued attribute problem.]
4. (4 pts) Draw the complete ER diagrams for the entities and their relationships for the Invoice Form below. Indicate weak entities and show cardinality. Again, be reasonable in the attribute listing you provide but be sure to show the identifier. This is the classic order form data model. Don’t forget you can use the lecture notes for reference. THIS WILL TAKE SOME TIME.
ADbC Reference: http://adbc.kennesaw.edu Database Design Scenario to ER
Assignment 3
Data Modeling and ER Diagrams
Review ER notation sets at http://adbc.kennesaw.edu Database Design ER Notations
Use how_to_draw_er_in_ppt.pptx or Gliffy to draw the models.
If you use Gliffy save your drawing as an image [jpg file] and insert it into a Word document (in fact just adding your images to this document would be a good idea).
Submit your word document if you used Gliffy or your powerpoint document via the D2L DropBox.
1. (2 pts) Examine the subscription form shown below. Using the structure of this form, do the following:
Create a model with two entities, one for customer and a second for subscription. Specify identifiers, attributes, relationships and cardinality
2. (2 pts) Draw the ERD for the following scenario. The only attribute you need to include is the IDENTIFIER. Be careful with your cardinality.
A patient has one or more patient histories; each instance of patient history belongs to one patient.
3. (2 pts) Draw the ERD for the following scenario. Include all the attributes. Note that one of your tables will have a composite identifier.
You want to maintain a list of your contacts. You retain the following information, lastname, firstname, address, city, state, zip code and phone numbers.
[Hint: note that the contacts can have multiple phone numbers – this is the classic multi-valued attribute problem.]
4. (4 pts) Draw the complete ER diagrams for the entities and their relationships for the Invoice Form below. Indicate weak entities and show cardinality. Again, be reasonable in the attribute listing you provide but be sure to show the identifier. This is the classic order form data model. Don’t forget you can use the lecture notes for reference. THIS WILL TAKE SOME TIME.
ADbC Reference: http://adbc.kennesaw.edu Database Design Scenario to ER