BUS 237 Lecture Notes - Lecture 5: Foreign Key, Database, Database Application

• School: Simon Fraser University
• Department: Business Administration
• Course: BUS 237
• Professor: Peter Tingling

Document Summary

Intellectual property- form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography. Cms (content management systems)- organizes content, usually on the internet. Dbms (database management systems)- enables integration with multiple. Byte > columns/ fields > rows/ record > table/ file. Master record: a record representing the status of a business entity. Transaction record: a record representing an event (change) in the business. Key- a column or group of columns that identifies a unique row in a table. Foreign key- keys of a different (foreign) table from the one in which they reside. Relational databases- are databases that carry their data in the form of tables and that represent relationships using foreign keys. Dbms (database application system)- is a program used to create, process, and administer a database (usually licensed from vendors) Sql (structured query language)- international standard language for processing a database.