8 - Database Design

8 - Database Design - 11/4/2011 BIT 200 Personal...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
11/4/2011 1 Session 8 Database Design BIT 200 Personal Productivity Upcoming Deliverable 9a, Access Tutorial 1 Deliverable 9b, Access Tutorial 2 Both due Monday, November 14 Next Week: Advanced Access Meet in Tozzi Lab (E1405) Bring your Access book Agenda What’s in the News Wiki Report: IT Security Reflection on Last Week Database Design Entity-Relationship (ER) Modeling Constructing ER Diagrams Converting ER Diagrams to Databases
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
11/4/2011 2 WHAT’S IN THE NEWS? 4 REFLECTION ON LAST WEEK Databases Databases A database is a repository of structured business data A database management system is software the controls the creation, maintenance, and use of a database Relational databases are structured as relations (tables) with attributes (columns) and records (rows) Attribute values (data) are contained in the body of the table A primary key uniquely identifies each record SQL (structure query language) is the standard language for defining and manipulating data in a relational database
Background image of page 2
11/4/2011 3 WIKI/TECH TOPICS PROJECT IT Security Learning Objectives for Today Understand problems caused by un-normalized data Understand third normal form Understand and be able to construct an entity- relationship (ER) diagram Be able to convert an ER diagram into a database design Be able to define important terms: Entity, attribute, and relationship Keys: primary, composite primary, or foreign
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
11/4/2011 4 DATABASE DESIGN Information System Components Hardware Data Information People Procedures Networks Databases 10010010 01010101 11001101 10010010 01010101 11001101 Software Example: Wolverine Access Putting All Data in One Table Creates Problems • Problems with ~ Insertions (adding new rows) ~ Updates (modifying existing rows) ~ Deletions (of a row) Primary Key ID Name Addr Stock Shares Price Dividend 3 Smith LA IBM 16 $81.00 $0.80 19 Jones NY WMT 5 $46.00 $0.60 37 Chan AA GE 12 $34.00 $0.50 102 Harris KC IBM 10 $81.00 $0.80 102 Harris KC WMT 5 $46.00 $0.60
Background image of page 4
11/4/2011 5 A Better Structure Split table into multiple tables
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/04/2012 for the course BIT 200 taught by Professor Moore during the Fall '08 term at University of Michigan.

Page1 / 13

8 - Database Design - 11/4/2011 BIT 200 Personal...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online