BUS 237 Lecture Notes - Database Application, Query Language, Management System

30 views2 pages
user avatar
Published on 15 Jul 2011
School
Simon Fraser University
Department
Business Administration
Course
BUS 237
Professor
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!
What's in a database?
What is a database? "a self-describing collection of integrated records."
Collumns= fields
Rows= 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.
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.
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.
Chapter 5
October-02-08
10:33 AM
MIS Chapter 5 Page 1
www.notesolution.com
Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

Document Summary

Intellectual property= creative endeavour protected through trademarks, patents, etc. People (employees) used to upload whatever they want. Organize documents for websites, seek out documents located across an organization. When there is more than one theme to the information that needs to be organized. 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. Data that describes data. (this should go here Date goes here time goes here info goes here) Column or group of columns that identifies a unique row in a table. 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 databases. Developers use it to create tables relationships and structures of the database. Dbms administers by setting up firewalls, passwords, etc.