Class Notes (809,749)
Canada (493,782)
York University (33,568)
ADMS 2511 (179)
all (24)

chapter_12 notes.docx

4 Pages
Unlock Document

York University
Administrative Studies
ADMS 2511

Chapter 12-Information Systems 12.3-Database Management Systems Chapter 12.3: Data Bases • Database: Astructured set of data. • Database Management System: (DBMS)Acombination of software and data, including: o Physical database: a collection of files that contain the data. o Database engine: software that supports access to and modification of the database contents. o Database schema: a specification of the logical structure of the data stored in the database. • Specialized database languages allow the user to: o specify the structure of data; o add, modify, and delete data; o query the database to retrieve specific stored data • Database schema provides the logical view of the data in the database • The Relational Model o Adatabase model in which data and relationships among them are organized into tables  Atable is a collection of records  Arecord (or object/entity) is a collection of related fields that make up a single database entry • rows  Each field (or attribute) contains a single data value • Columns o Key one or more fields of a database record that uniquely identifies it among all other records in the table • Relationships o Records represent individual database objects o Fields of a record are attributes of these objects  Shows example of customer and movie relationship in a new table • Certain info is omitted b.c you can find it in the original table • Table is constantly updated w/ returns and rents of movies o Also can add new customers • Structured Query Language o Acomprehensive database language for managing relational database  Includes statements that specify database schemas as well as statements that add, modify, and delete database content o SQL is not case sensitive  Keywords, table names,
More Less

Related notes for ADMS 2511

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.