1 / 13

First class agenda

This course provides an introduction to database design and ER notation, covering topics such as logical and physical database modeling, entity relationships, and alternative notations. Students will review slides, iterate through design, and translate into a physical model. The class also covers UML notation and different types of diagrams. Next class will focus on SQL review and modeling. Students should start thinking about Oracle project ideas and group formation.

kovar
Download Presentation

First class agenda

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. First class agenda • Introductions • Course overview • http://ils.unc.edu/chaffin/258/ • Password protected items will use inls258 / WeR258! as the userid/password combination • To turn in work, • Use class inbox (\\kiwi\home\chaffin\shared\inls258\inbox) • Email as an attachment (after compressing!) • Review slides?

  2. Database design and ER notation review

  3. DB design • Develop logical model of database • Entities • Relationships • Iterate through design • Translate into physical model of database

  4. ER Notation: Basic Symbols member student job-title Attribute Relationship Entity D Superclass – Subclass Connector

  5. Attributes Optional Attribute Basic Attribute bdate dr-license student SID age Primary Key Derived Attribute hobby street Multi-valued Attribute address city Composite Attribute state zip

  6. Relationships writes masters paper student one-to-one 1:1 optional participation advises advisor student one-to-many 1:M student enroll course many-to-many M:N

  7. Alternative notations writes 1 1 masters paper student advises (1,1) (0, N) advisor optional participation student student enroll N course M

  8. Superclass/subclassOverlapping/disjoint student student O D MSIS MLS ASIS member SCALA member SLA member

  9. uses M N Project Skill P Employee ternary relationships During physical design, these must be broken into several binary relationships.

  10. UML notation employee EID: string Name: string Job: string change_job_class give_raise(sal, amount):number change_manager

  11. UML • Types of diagrams used • class diagrams • class diagrams with interfaces • activity diagrams • use case diagrams • state diagrams

  12. Coming up… • Next time • Meet in the classroom (Wed is next class) • SQL review and modeling • Be thinking about Oracle project ideas and groups and your current issues presentations!

More Related