iSYS 340: Introduction to Database Application Systems
(Note: This course was COMS 340: Database Management Systems I before the 2007-8 catalog.)
Contents
Introduction to the concept of database systems; database models; database management systems; file organization; design of databases using data modeling and normalization; conversion of data model into relational, network, and hierarchical data models; extensive coverage of SQL and implementation of an application using a relational database in a team environment. Cross-listed with IT as IT 340.
This course (iSYS 340) is a prerequisite for the following iSYS course(s):
This course is normally scheduled every fall and spring semester.
(under construction...)
The following content areas will be covered.
- Database Terminology and Concepts (about 12 hours)
- DBMS Structure (about 2 hours)
- Conceptual Modeling Techniques (about 14 hours)
- Logical Database Modeling (about 2 hours)
- Physical Database Modeling (about 2 hours)
- Relational Normal Forms (about 8 hours)
- Database and IS Implementation (about 4 hours)
- DB Application Development (about 4 hours)
- Structured Query Language (SQL) (about 12 hours)
Additional topics may also be covered based on time and student interest.
By the end of this course, you should be able to
- construct several simple queries to look at data in a relational database system
- from a workflow drawing or other requirements documents, construct a simple multi-table database
- identify and define parts of a DBMS (e.g., query optimizer, concurrency control subsystem)
- explain the purpose of each of the major constructs of a conceptual data model, such as the E/R model
- explain the logical purpose of a primary key
- explain how a multilevel index works
- change a 2NF table into at least 3NF through decomposition
- change a 3NF table into at least BCNF through decomposition
- given a table in an unknown normal form along with a list of dependencies, determine the highest normal form of that table
- list database systems development and retrieval facilities needed to facilitate creation of information system applications
- give an example of an OLAP application
- give an example of an OLTP application
- understand cardinality and optionality in a data model
- understand unary, binary, and ternary relationships
- create a normalized data model from business rules
- explain the reasons for specific commands within the data manipulation facilities
Final textbook choice is determined by the instructor, who may choose a textbook similar to one the following. This list can give you an idea of the course topics, coverage, and depth.
"Database Systems Design, Implementation, and Management" by Rob and Coronel. 7th Edition. ISBN = 1-418-83593-5
•
Additional readings may be assigned by the instructor.
