1 / 13

IST 318 – DB Administration

IST 318 – DB Administration. Intro to Relational Model, Normalization, and SQL. RDB Terminologies. RDBMS. RDBMS Functions. System Dev. Life Cycle (SDLC). SDLC Illustration. E and R. DB design should focus on organization (Management of Data), not limited to the Data (or numbers)

malory
Download Presentation

IST 318 – DB Administration

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. IST 318 – DB Administration Intro to Relational Model, Normalization, and SQL

  2. RDB Terminologies

  3. RDBMS

  4. RDBMS Functions

  5. System Dev. Life Cycle (SDLC)

  6. SDLC Illustration

  7. E and R • DB design should focus on organization (Management of Data), not limited to the Data (or numbers) • What kinds of data are needed?  entities • Real world people, objects, processes, concepts • Turn into tables • How are these kinds of data are related?  relationships • Turn into constraints (and sometimes tables)

  8. Cardinality • One important type of relationship Binary relationship • The most commonly considered constraint on a binary relationships is cardinality, or number of instances that may appear through this relationship • One to one • One to many • Many to many

  9. ER Diagram • Notice the notations for • Entities • Relationships • Cardinality constraints

  10. Normalization – Why it’s needed? • Notice the redundancy in the dataset (modeled with a single entity/table)? • Problems (or anomalies) that can be induced • Insertion, deletion, and update anomalies • Normalization (or splitting into multiple tables) is the solution

  11. Normalization – How to Do It? • Split a “wide” table into a number of “narrow” ones that are in the third normal form (3NF) • 1NF: data in every field is atomic, and the record has a (primary) key • 2NF: all fields depend on the whole key • 3NF: every field depends on the key directly, not through another (set of) field(s)

  12. Sample Tables in 2/3NFs

  13. ERD for The Sample Bookstore DB

More Related