MIS 2000 Lecture Notes - Lecture 4: Ibm Db2, Database, Microsoft Access

• School: BGSU
• Department: Management Information Systems
• Course: MIS 2000
• Professor: Bethany Niese

Document Summary

Specifies the type of data, the maximum number of characters whether it"s a. What are the components of a database application system: database, dbms (database management system, database application(s, databases are self-describing collections of integrated records, database management systems are software used to create, process and administer databases. Maximum cardinality- maximum number of entries that can be involved in a. Structured query language: creates the database and is structures, processes the database, administers database. Database design: process of converting a dara model into tables, relationships and data constraints. Converting poorly structured tables into two or more well-structred. Eliminating duplicate data can do by breaking out into more tables. Each table should have only 1 (cid:498)theme(cid:499) and creating a relationship. Users are final judges as to the data in the database. Users should review the data models before developing the database.