Data has emerged as a strategic resource and hence, like other strategic resources (e.g. human and financial) must be managed with care and rigor. Today, business enterprises may prosper if they effectively process, analyze, and synthesize their data to produce timely and accurate information. The course will provide you (using lectures, classroom discussion, case studies, and laboratory exercises) with adequate technical knowledge of database systems while emphasizing planning, administrative and implementation issues necessary for successful management of corporate data resources.
The objective of this course is to cover the fundamentals of database modeling, design and implementation and to learn how to create integrated Web database applications. There are various approaches to designing databases. These approaches are continually evolving. You will learn Entity Relationship models and normalization as tools for designing databases. Relational databases are emphasized throughout the course. Databases are implemented on software packages with an emphasis on SQL. Current trends in database technology are also discussed.
Briefly, the following are the main objectives of the course:
1. Understand the basic concepts of database systems
2. Learn how to use the Structured Query Language (SQL)
3. Be able to design a "good" relational database
4. Foster an appreciation of databases as an useful tool in the workplace
5. Learn how to use a commercial DBMS
6. Learn how to create integrated Web database applications

Database Management Systems Notes:

 

1	Course Outline
2	Defining the DATA, DBMS, Database System, Database Design, and Data Dictionary etc. (Introduction to DBMS Subject).
3	E-R model and E-R Diagram
4	Modeling Data in an Organization
5	The Enhanced E-R model and Business Rules
6	Logical Database Design and the Relational Model
7	Structured Query Language (SQL)
8	STRUCTURED QUERY LANGUAGE (SQL) Continued
9	Advanced SQL
10	The Client/Server Database Environment
11	The Internet Database Environment