BUS 237 Lecture Notes - Database Application, Query Language, Management System
nilimasyeda and 38821 others unlocked
6
BUS 237 Full Course Notes
Verified Note
6 documents
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.