CS 159A Database Design and Modeling (3)
Credit, Degree Applicable
A course in the design of database structures and the use of database modeling tools.
Offered on occasion
After successful completion of this course, students will be able to:
- Outcome 1: Create the relations and relationships for a database based on a completed E- R (Entity Relationship) or UML (Unified Modeling Language) design.
- Outcome 2: Create an ER model and a database structure, including normalized tables and procedures, using a well-defined set of business rules.
- Outcome 3: Analyze business needs and design roles and views for various users of the system.
- Outcome 4: Analyze a poorly-defined or incomplete set of business rules, identify potential design problems and propose and test solutions.
- Outcome 5: Compare and contrast the advantages and disadvantages of denormalizing relations.
- Outcome 6: Describe security, privacy and ethics concerns as they relate to database system design.