SMG IS 223- Final Exam Guide - Comprehensive Notes for the exam ( 26 pages long!)

• School: Boston University
• Department: Information Systems
• Course: SMG IS 223
• Professor: Jesse Shore

Document Summary

Can keep track of more complex things, i. e just grades vs. office visits, grades, and emails. Is a self describing collection of integrated records. Bytes grouped into columns (or fields) grouped into rows (records) table or file. Databases are normally stored on magnetic disks. A primary key is a column or group of columns that identifies a unique row in a table usually in the form of id numbers that pertain to the table. Foreign key represents keys of a different table than the one they exist in. Databases contain not only data but also data about the data in the database. Examples of metadata include field name, data type, and description. Format of metadata depends on the software that is being used. A database management system is a program used to create, process, and administer a database. Vendors like ibm, access, and sql server. Developer opens the metadata to create tables, relationships and other structures in the database.