MIS 301 Chapter Notes - Chapter 13: Query Language, Unique Key, Foreign Key

• School: UT-Austin
• Department: Management Information Systems
• Course: MIS 301
• Professor: Rock Joshua

Document Summary

Data collected is doubling every 2 years or 6 months for hardware. Top ranked companies were more productive and profitable. Everything is now data driven fact based decision making. Business intelligent -- combining data exploration, ad hoc queries, sophisticated data modeling, and analysis. Analytics: extensive use of data and analysis to drive decisions. True strategic asset when rare, valuable, imperfectly imitable, and lacking in substitutes. Dynamic pricing: changing prices based on demand. Becomes information when presented in context so it can answer a question. Created, maintained and manipulated using database management systems (dbms)/database software. Sql: structured query language -- most common language. A table or file refers to a list of data. A database is either a single table or a collection of related tables. The course registration database above depicts five tables. A (cid:272)olu(cid:373)(cid:374) o(cid:396) field defi(cid:374)es the data that a ta(cid:271)le (cid:272)a(cid:374) hold.