Overview
Description
All issues related to the design and implementation of relational database systems; emphasizes entity relationship modeling, normalization and SQL programming with a relational DBMS.
Requirements
Prerequisites
- Business major or minor
IS 201IS 350CS 135
Original catalog text
Prerequisites
IS 201; IS 350 or CS 135; Business major or minor.
Units
Lecture3
Catalog Details
Offering
Offered: Every Fall and Spring
Terms
fall, spring
Restrictions
Business major or minor
Attributes
Standard
Learning Outcomes
- design a database using the normilization process that is stable and understand why your design is stable.
- use entity-relationship diagrams (ERD’s) to depict the design of a database.
- use ERD’s to communicate design concepts with both technical and non-technical people.
- use structured query language (SQL) to create, update, and access data in a database.
- identify the objectives and design goals of a transaction database versus a data warehouse.
- describe the general components of a database management system.
- describe the job activities that are the responsibilities of a database administrator.