


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
An introduction to databases, focusing on business intelligence and the relational database model. Topics covered include the role of operational databases in business intelligence, online transactional and analytical processing, the structure of a relational database, primary and foreign keys, and database management systems. The document also discusses the importance of integrity constraints in maintaining data quality.
Typology: Study notes
1 / 4
This page cannot be seen from the preview
Don't miss anything!
Databases September 18 – September 22
your business partners, your competitive environment, and your own internal operations – that gives you the ability – that gives you the ability to make effective, important, and often strategic business decisions (p. 124).
business intelligence (p. 124).
processing, and updating of information in an operational database. Online analytical processing (OLAP) is the manipulation of information to support decision making (p. 124).
database model is one that consists of multiple tables that they are related (p. 127). ORDER TABLE Order Number Order Date Customer Number Concrete Type Amount (Tons) 10000 9/1/2004 1234 1 8 10001 9/1/2004 3456 1 3 10002 9/2/2004 1234 5 6 10003 9/3/2004 4567 2 4 10004 9/5/2004 3456 3 6 CUTOMER TABLE Customer Number Customer Name Customer Phone Customer Address 1234 Smelding Homes 662-329-7164 55 Smith Lane 3456 Mark Akey 662-312-4589 2122 E. Biscayne 4567 Triple A Homes 662-325-1560 1333 Burr Ridge
Concrete Type Type Description 1 Home foundation and walkways 2 Commercial foundation 3 Premier speckled 4 Premier marble 5 Premier shell
database consists of columns, each of which is known as a field.
data dictionary (p. 126).
be unique in that it uniquely identifies a record. (p 128). For example, your SSN would be the primary key in the MUW databases that uniquely identify you. Looking at the tables above, Order Number is the primary key for the ORDER TABLE, Customer Number is the primary key for the CUSTOMER TABLE, and Concrete Type is the primary key for the CONCRETE TYPE TABLE.
think of it as a pointer. It “points” at the primary key of another table. (p. 128). A foreign key does not have to be unique. The name of a foreign key must match the name of a primary key of another table exactly. The values stored in a foreign key must match a value stored in the primary key of another table exactly. Customer Number is a foreign key in the ORDER TABLE (it “points” at the Customer Number primary key in the CUSTOMER TABLE). Concrete Type is also a foreign key in the ORDER TABLE (it “points” at the Concrete Type primary key in the CONCRETE TYPE TABLE). o Here’s an example. Focus on the 10002 order in the ORDER TABLE. We know that this order was sold to Smelding Homes (because the Customer Number 1234
as a knowledge worker need to arrange and access information to meet your business needs (p. 130).
defines the structure of the files (p. 131).
information in a database and query it for valuable information (p. 132).
changes you want, perform simple sorting, and query it to find the location of specific information (p. 133).
information you want to see in a report (p. 134).
transaction-intensive applications (p. 136).
environment by providing facilities for backup and recovery, security management, etc. (p. 136).