BUS 237 Lecture Notes - Database Application, Query Language, Management System
SchoolSimon Fraser University
Course CodeBUS 237
This preview shows half of the first page. to view the full 2 pages of the document.
What is content?
Property of an industry (information property)
Intellectual property= creative endeavour protected through trademarks, patents, etc.
Database management systems
People (employees) used to upload whatever they want. Now there is a specific channel:
Content management systems
Organize documents for websites, seek out documents located across an organization.
What's the purpose of a database? To keep track of things!
When is one necessary? When there is more than one theme to the information that needs to be
What's in a database?
What is a database? "a self-describing collection of integrated records."
Similar rows or records=table/file
Thus a database is a collection of tables, the relationships within the rows in the tables, and special data
(metadata) which describes the structure of the database.
K so what is metadata? Data that describes data. (this should go here... Date goes here... Time goes
here... Info goes here...)
Key=top left box in a table
Column or group of columns that identifies a unique row in a table
Every table must have a key
Foreign keys= keys of a different table that are not the keys in the present table.
Tables with keys and foreign keys (tables that have info from other tables) are called relational
More on the database management system:
Creates processes and manages the database.
Developers use it to create tables relationships and structures of the database
Standard query language (SQL)
Language for processing database
DBMS administers by setting up firewalls, passwords, etc.
Database application is a collection of forms, reports, queries and application programs (process
database) so these applications use the info in the database in different ways.
MIS Chapter 5 Page 1
You're Reading a Preview
Unlock to view full version