MIS 114 - Database Management Systems for Business

MIS 150

Data Base Systems for Business

Monday and Wednesday, 1:15-2:45 p.m., Library 127

Description: Involves the study of generalized database management systems. The study will include logical data base models and physical base models based primarily on the relational and object-relational models. The student will create and manipulate a database utilizing an established database management system. The importance of data administration and other database related topics such as independence, integrity, privacy, query, backup, and recovery will be covered. Prerequisite: MIS 120, MIS 175. 3 units.

Note. Oracle9i and Oracle Developer (version 6) for Windows XP will be used. See instructions before installing them. Warning! To correct any installation problems (i.e., incorrectly installed Oracle software), you must first uninstall everything and then delete them from the Windows registry. Thus, it's best to follow the instructions.

CLASS ROSTER

*** Database project has been posted (under "Assignments"). ***

[Syllabus | Exam Essay Questions| Handouts and Class Notes|Assignments| Home ]
[FYI]

Textbooks

Database Systems: A Practical Approach to Design, Implementation and Management, 4th edition, Thomas Connolly and Carolyn Begg. Addison Wesley (2005), ISBN: 0 321 21025 5. (Required)

Syllabus

Syllabus
School of Business Administration Add/Drop Policy Please read.

Top of page

Exam Essay Questions

Exam1 Essay Questions (updated: Oct. 9)

Final Exam Essay Questions (updated: Dec. 5)

Top of page

Handouts and Class Notes

Week 1 - Introduction (updated: Aug. 29)
Week 2 - Database vs. file-based systems (updated: Sept. 7)
Week 3 - Three-level architecture, DBMS, relational data model, views (updated: Sept. 12)
Week 4 - Relational algebra and calculus, intro to SQL: projections and joins (updated: Sept. 19)
Week 5 - Oracle control files, basic data types, SQL: creating and altering tables, integrity constraints, DML (updated: Sept. 26)
Week 6 - SQL: Joins, set operations, aggregation functions, subqueries ANY/ALL and EXIST/NOT EXIST, table INSERT, DELETE and DROP; Oracle: Format models, SUBSTRing, TRUNCation and MODulus functions (Updated: Oct. 3)
Week 7 - Host and lexical reference variables, database planning (updated: Oct. 10)
Week 8 - Database planning and design, ERD (updated: Oct. 19)
Week 9 - ERD (updated: Oct. 23)
Week 10 - Data normalization (updated: Oct. 30)
Week 11 - Data normalization, database design methodology: conceptual, logical and physical database design (updated: Nov. 9)
Week 12 - Answer to Homework 3, part 1 (updated: Nov. 14)
Week 12 - Answer to Homework 3, part 2, physical database design (updated: Nov. 16)
Week 14 - Database security, transaction management and concurrently controls, distributed DB, database warehousing, data marts and MMDBMS, OODBMS (updated: Nov. 28)
Week 15 - No classes (work on DB project)

Top of page

Assignments

Homework 1 - SQL and Oracle9i (updated: Sept. 25)
Distributors dump file, videos and video_categories control files (compressed in a zip file)
Oracle SQL Reference (pdf file)
Homework 2 - Oracle Reports (updated: Oct. 20)
Video categories and videos dump file - Made available for those who may have had difficulty with homework 1.
Homework 3 - Data normalization and ERD (updated: Nov. 10)
Homework 4 (optional) - Oracle Graphics Builder (updated: Nov. 12)
Video sales dump file
Project (updated: Nov. 20)

Order form

Catalog pages

Peer evaluation form

Top of page

FYI

Top of page

Get Adobe Reader

Return