Data Modeling wrapping up from last week Homework
- Slides: 16
+ Data Modeling (wrapping up from last week)
+ Homework Review n Exercise 4. 32 – Develop a data model of a genealogical diagram. Model only biological parents; do not model stepparents. Use the IE Crow’s Foot E-R model for your E-R diagrams. n Break into groups of 4 -6. Develop your diagram. n Elect one person to draw it. n Elect one other person to describe it’s features. n How do our models differ? n What are we learning about data modeling? KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ ER Diagram n Draw an simple ER Diagram for the Premiere Products company that we talked about last class. KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Developing an E-R Diagram n Heather Sweeney Designs will be used as an ongoing example throughout Chapters 4, 5, 6, and 7. n Heather Sweeney is an interior designer who specializes in home kitchen design. n She offers a variety of free seminars at home shows, kitchen and appliance stores, and other public locations. n She earns revenue by selling books and videos that instruct people on kitchen design. n She also offers custom-design consulting services. KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: The Seminar Customer List Figure 4 -15: Example Seminar Customer List KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Initial E-R Diagram I (a) First Version of the SEMINAR and CUSTOMER E-R Diagram Figure 4 -16: Initial E-R Diagram for Heather Sweeney Designs KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Initial E-R Diagram II (b) Second Version of the SEMINAR and CUSTOMER E-R Diagram Figure 4 -16: Initial E-R Diagram for Heather Sweeney Designs KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Initial E-R Diagram III (c) Third Version of the SEMINAR and CUSTOMER E-R Diagram Figure 4 -16: Initial E-R Diagram for Heather Sweeney Designs KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: The Customer Form Letter KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Data Model with CONTACT (a) First Version with CONTACT Figure 4 -18: Heather Sweeney Designs Data Model with CONTACT KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Data Model with CONTACT as Weak Entity (b) Second Version with CONTACT as a Weak Entity Figure 4 -18: Heather Sweeney Designs Data Model with CONTACT KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Sales Invoice Figure 4 -19: Heather Sweeney Designs Sales Invoice KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Data Model with INVOICE (a) Version with INVOICE Figure 4 -20: The Final Data Model for Heather Sweeney Designs KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Data Model with LINE_ITEM (b) Version with LINE_ITEM Figure 4 -20: The Final Data Model for Heather Sweeney Designs KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Final Data Model (c) The Finished Data Model Figure 4 -20: The Final Data Model for Heather Sweeney Designs KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
+ Heather Sweeney Designs: Business Rules and Model Validation n Business rules may constrain the model and need to be recorded. n Heather Sweeney Designs has a business rule that no more than one form letter or email per day is to be sent to a customer. n After the data model has been completed, it needs to be validated. n Prototyping and reports. is commonly used to validate forms KROENKE and AUER - DATABASE CONCEPTS (6 th Edition) Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
- Did you do your homework
- Last week's homework
- Last week's homework
- Modeling role modeling theory
- Dimensional modeling vs relational modeling
- Week by week plans for documenting children's development
- Data warehouse modeling best practices
- Week 16 homework: penetration testing 1
- Homework oh homework
- Homework oh homework i hate you you stink
- Jack prelutsky homework oh homework
- Homework oh homework
- Homework oh homework i hate you you stink
- Literal language
- I stay at home last weekend
- What did you do last week?.......in the pool.
- They broke the window last week