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

• School: Simon Fraser University
• Department: Business Administration
• Course: BUS 237
• Professor: Kamal Masri

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.