chapter01

chapter01 - Concepts of Database Management Sixth Edition...

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

View Full Document Right Arrow Icon
Concepts of Database Management Sixth Edition Chapter 1 Introduction to Database Management
Background image of page 1

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 2 Objectives Introduce Premiere Products, the company that is used as the basis for many of the examples throughout the text Introduce basic database terminology Describe database management systems (DBMSs) Explain the advantages and disadvantages of database processing
Background image of page 2
Concepts of Database Management 3 Objectives (continued) Introduce Henry Books, the company that is used in a case that appears throughout the text Introduce Alexamara Marina Group, the company that is used in another case that appears throughout the text
Background image of page 3

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 4 Premiere Products Background Premiere Products Distributor of appliances, houseware, and sporting goods Uses spreadsheet software to maintain important data Recent growth has made spreadsheet approach problematic
Background image of page 4
Concepts of Database Management 5 Premiere Products Background (continued) FIGURE 1-1: Sample orders spreadsheet
Background image of page 5

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 6 Premiere Products Background (continued) Problems using spreadsheet Redundancy Duplication of data or the storing of the same data in more than one place Difficulty accessing related data Limited security Size limitations
Background image of page 6
Concepts of Database Management 7 Premiere Products Background (continued) Information Premiere Products needs to maintain Sales Reps Sales rep number, last name, first name, address, total commission, commission rate Customers Customer number, name, address, current balance, credit limit, number of customer’s sales rep Parts Inventory Part number, description, number units on hand, item class, warehouse number, unit price
Background image of page 7

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 8 Premiere Products Background (continued) FIGURE 1-2: Sample order
Background image of page 8
Concepts of Database Management 9 Premiere Products Background (continued) Items for each customer’s order Order Order number, order date, customer number Order line Order number, part number, number units ordered, quoted price Overall order total Not stored since it can be calculated
Background image of page 9

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

View Full DocumentRight Arrow Icon
Concepts of Database Management 10 Database Background Database Structure that can store information about: Different categories of information Relationships between those categories of information Entity Person, place, object, event, or idea Entities for Premiere Products: sales reps, customers, orders, and parts
Background image of page 10
Concepts of Database Management 11 Database Background (continued) Attribute Characteristic or property of an entity Example: Customer has name, street, city, etc. May also be called a
Background image of page 11

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

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

This note was uploaded on 01/11/2012 for the course CIS 240 taught by Professor Last during the Spring '11 term at NYU.

Page1 / 49

chapter01 - Concepts of Database Management Sixth Edition...

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

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