Catalog Course Description:
Focuses on how to design databases for given problems, and how to use database systems effectively.  Topics include database design techniques using the entity-relationship (ERD) approach, techniques of translating the ERDs into a relational schema, set operations (union, union all, intersect, and minus), commercial query languages, and normalization techniques.

Pre-requisites and Co-requisites:
INFO 102 Minimum Grade: D or SE 210 Minimum Grade: D or ISYS 200 Minimum Grade: D

Curriculum Role:
This course is offered to students who have no formal training in database systems and presents basic theory and technology for database design.  This is a required course for the BSIS, BSIT and BSSE undergraduate curriculums.

Course Rationale:
This course establishes the theoretical background of relational databases, database query language and database design. This course is offered for students who want to be a database expert for conceptual database design.

Course Outcomes:
Upon successful completion of this course the learner will be able to:
• specify the fundamental concepts necessary for the design, use, integrity maintenance, and implementation of database systems.
• arrange an entity-relationship diagram (ERD) into a relational schema.
• construct a database for a given problem from a relational schema.
• set up relational algebra (set operations) and contemporary query language statements (SQL).
• formulate simple database application programs.
• transform a relation into 1st, 2nd, 3rd normal forms.
• analyze the issues and problems in relational database systems.
• summarize the components of database management systems.
• recognize the evolving roles of database systems in an enterprise.

Course Content:
• Principal topics and the approximate number of weeks devoted to each are:
• Database design using the entity-relationship model, techniques of translating ER diagrams into relational schema (2)
• The basic concepts and components of DBMS (1)
• Commercial query languages (2)
• Functional dependencies and normalization (1)
• Fundamentals of relational model, set operations, and query languages (2)
• Relational database systems including integrity constraints and relational algebra (2)

Presentation:
Note: Presentation method may vary somewhat from section to section.
Lecture presentation.

Assessment:
Note: Assessment method may vary somewhat from section to section.
Assignments and examinations.