Transcript Chapter 1
1 Chapter 1 Introduction to Database Management Concepts of Database Management, 4th Edition, Pratt & Adamski 1 Objectives 1 Introduce Premiere Products, the company that is used as the basis for many of the examples throughout the text Introduce Describe basic database terminology database management systems Explain the advantages and disadvantages of database processing Introduce Henry Books, the company that is used in the case that runs throughout the text Concepts of Database Management, 4th Edition, Pratt & Adamski 2 Premiere Products 1 Distributor of appliances, housewares, and sporting goods Uses spreadsheet software to maintain important data Recent growth has made the spreadsheet approach problematic Redundancy Difficulty accessing data Limited security Size limitations Concepts of Database Management, 4th Edition, Pratt & Adamski 3 Premiere Products Required Information Sales 1 Reps Sales rep number, last name, first name, address, total commission, commission rate Customers Customer number, name, address, current balance, credit limit, customer sales rep Parts Inventory Part number, description, number units on hand, item class, warehouse number, unit price Concepts of Database Management, 4th Edition, Pratt & Adamski 4 Premiere Products Sample Order Figure 1.2 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 5 Premiere Products Customer Order Order Order number, order date, customer number Order line 1 Order number, part number, number units ordered, unit price Overall order total Not stored since it can be calculated Concepts of Database Management, 4th Edition, Pratt & Adamski 6 1 Database Background Database Structure to store information about multiple types of entities, attributes, and relationships Entity Person, place, thing, or event Premiere Products has sales reps, customers, orders, and parts Attribute Property of an entity Customer has name, street, city, et cetera Concepts of Database Management, 4th Edition, Pratt & Adamski 7 Entities and Attributes Figure 1.3 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 8 1 Database Background (con’t.) Relationship Association between entities Rep is related to many customers Customer is related to a single rep Data file File used to store data Computer counterpart to ordinary paper file Concepts of Database Management, 4th Edition, Pratt & Adamski 9 One-to-Many Relationship Figure 1.4 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 10 Rep and Customer Tables Figure 1.5 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 11 Orders and OrderLine Tables Figure 1.5 (con’t.) Concepts of Database Management, 4th Edition, Pratt & Adamski 1 12 Part Table Figure 1.5 (con’t.) Concepts of Database Management, 4th Edition, Pratt & Adamski 1 13 Alternative Orders Table Figure 1.6 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 14 1 Database Management Systems Program(s) through which users interact with database Popular DBMSs include Access, Oracle, DB2, SQL Server Premiere Products decides to use Access Concepts of Database Management, 4th Edition, Pratt & Adamski 15 Using DBMSs in Different Ways Figures 1.7 and 1.8 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 16 1 Building a Database Database design determines the structure of a database Design entered into DBMS during Construction Tables Forms Reports Switchboards Concepts of Database Management, 4th Edition, Pratt & Adamski 17 Part and Order Forms Figures 1.9 and 1.10 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 18 Parts Report Figure 1.11 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 19 Switchboards Figure 1.12 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 20 Switchboards (con’t.) Figure 1.13 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 21 Advantages of Database Processing Figure 1.14 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 22 Disadvantages of Database Processing Figure 1.15 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 23 Introduction to Henry Books Database Case 1 Book store chain operated by Ray Henry Henry decided to use database to gather and store information on: Branches Publishers Authors Books Concepts of Database Management, 4th Edition, Pratt & Adamski 24 Sample Branch Data Figure 1.16 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 25 Sample Publisher Data Figure 1.16 (con’t.) Concepts of Database Management, 4th Edition, Pratt & Adamski 1 26 Sample Author Data Figure 1.17 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 27 Sample Book Data Figure 1.18 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 28 Wrote Table Relates Authors to Books Figure 1.19 Concepts of Database Management, 4th Edition, Pratt & Adamski 1 29 Inventory Table Relates Branches to Books Figure 1.19 (con’t.) Concepts of Database Management, 4th Edition, Pratt & Adamski 1 30