Course Introduction (Out of Class)

Welcome to the Database Design Systems (DBS).

DBS has evolved from a specialized computer application to a central component of a modern computing environment, and, as a result, knowledge about database systems has become an essential part of an education in computer science. 

In this course, we present the fundamental concepts of database management. These concepts include aspects of database design, database languages, and database-system implementation.
This course is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate, level. 

The course consists of two main parts, the first part will cover the conceptual design of databases using the entity- relationship model, and the relational data model.  The second part will discuss how data can be accessed using Relational Algebra and SQL. The assignments will require students to demonstrate their mastery of the practical aspects of Oracle SQL/ MYSQL and database design.

Upon successful completion of the course, it is expected that the student will be able to:

1. Define basic database terms
2. Explain the advantages and disadvantages of various database systems
3. Explain the nature and function of business rules
4. Explain the process of determining an organization’s data needs and 
5. Design database systems to meet these needs.
6. Create, read and modify entity relationship diagrams from an organization’s business rules.
7. Normalize database tables up to 3rd. normal form
8. Create, read and modify relational schemas and create working databases in a suitable platform.
9.  Apply Structured Query Language to create, access, and manage databases.
10. Identify and document database security issues