Database Design

1. Database Design MIS 320 Kraig Pencil Winter 2011 1

2. Game Plan Introduction Data base design Database scenario Key questions/answers 2

3. A. Introduction Remember � ? CNN: Internet is �Top innovation� of past 25 years (1/18/05) But Kraig Pencil says � The relational database is equally important Really? Why? The Internet would not be nearly as successful without relational databases providing rich information. 3

4. A. Introduction You can ask a database questions How many cans of chicken soup do we have in inventory? How large is the average pay raise in each department? Who are my best/worst customers? What else have I-Pod buyers also purchased? Is this airline passenger a known terrorist? Who has friended Gayle Zhang? Who else might Gayle want to consider friending? With the right data and a well-designed database, you can ask anything. 4

5. A. Introduction Who works with databases? Database programmers Database analysts Database designers Database administrators Data administrators Website designers/programmers Many non-IT users! Marketers Financial analysts Human resources managers �. And more 5

6. A. Introduction What does an organization do with data/information? Capture, cradle, and process transaction data/information e.g., TPS Use information to make decisions e.g., DSS �Oversee� the information e.g., Who can view or use what info?, How to back up info?, How long to retain info? What can help support the above? A database management system