Course Description
This is an introductory course appropriate for students with no experience in database management systems and with no knowledge of Structured Query Language (SQL). Although several database models are briefly presented, the course focuses on the relational model, the basis for most currently installed production database management systems (DBMS). The course covers the principles of database design and implementation including relational concepts, data modeling, conceptual and logical database design, use of SQL as a data-manipulation language, and current issues in database administration.
Learning Objectives
- Summarize the advantages/disadvantages of the relational model in resolving users’ needs for storing, organizing, accessing, and protecting data,
- Explain relational theory as the conceptual basis for relational database management systems,
- Analyze organizational artifacts to identify entities, attributes, relationships, and constraints,
- Create an entity-relationship diagram in Universal Modeling Language (UML),
- Develop a normalized schema from an entity-relationship diagram,
- Construct an operational database in a database management system,
- Write SQL statements for data manipulation, retrieval, and organization.
