CSC 459- 3 Semester Hours

Data Base Management Systems

Introduction to the design and structure of data bases. models, implementation, and maintenance of data base systems.

CSC 365

The theory and practice surrounding Databases form a central role in the design and development of most software systems and applications.

Software Engineering Curriculum Justification: This course provides in-depth content-oriented coverage of software requirements, configuration, design, construction, maintenance, validation, system integration, tools, and project management.

Upon successful completion of this course, students will be able to:

1. Analyze, design, verify, validate, implement, and deliver software systems incorporating databases.
2. Apply knowledge of discrete mathematics in the context of database design and analysis.
3. Construct database schema to meet given user requirements.
4. Communicate effectively about database design and development
5. Use database development and management tools.
6. Understand the fundamental concepts and theory of database modeling and design.
7. Perform database administration and performance tuning techniques.
8. Understand current topics in the field, such as Optimization, Distributed Databases

1. Preliminaries
   1. Review of software modeling, analysis, validation, verification, evolution, and quality management;
   2. Semantic modeling and GUI design principles
   3. Database Management and Database System Architectures
2. Database Modeling
   1. Syntax and semantics of relational algebra/relational calculus
   2. Logical design and normalization
   3. Data definition and data modeling in languages such as SQL and QBE
3. Engineering Enterprise Systems
   1. Using a major DBMS, such as, Oracle
   2. Web, mainframe, and client/server programming
   3. Object Oriented Database Model and programming
   4. Database administration and performance tuning techniques.
   5. Query Optimization and database analysis.
   6. Distributed Databases.

1. Lectures
2. Projects

1. Readings from a main text
2. Exercises
3. Projects, both individual and group, entailing understanding of how databases are designed and used, and experience with requirements, design, implementation, testing, documentation, and broader context of use.

1. Examinations.
2. Exercises
3. Project presentations and submissions

This required modeling tools, such as, TogetherSoft for modeling and prototyping databases, as well as access to a fully functional major DBMS, such as Oracle, along with with tuning tools.

C. J. Date, Introduction to Database Systems, 8th edition. Addison Wesley. 2003.

J. Hoffer, M. Prescott, and F. McFadden Modern Database Management, 8th edition. Prentice Hall, 2007.

G. Riccardi. Principles of Database Systems with Internet and Java Applications. Addison Wesley, 2001

J. Morrison, and M. Morrison, M. Creating SQL Server 2005 Applications with Visual Studio. Pearson Prentice Hall, 2007.

M. Loomis, The Database Book. Macmillan Pub Co. 2001.

M. Mannino, Database design, Application Development, and Administration. McGraw Hill, 2007.

M. Kifer, A. Bernstein, and P. Lewis, Database Systems - An Application-Oriented Approach. Addison Wesley, 2006.