|
|
|
Dec 06, 2025
|
|
University General Course Catalog 2016-2017 ARCHIVED CATALOG: LINKS AND CONTENT ARE OUT OF DATE. CHECK WITH YOUR ADVISOR.
|
IS 475 - Database Design and Implementation (3 units)
All issues related to the design and implementation of relational database systems; emphasizes entity relationship modeling, normalization and SQL programming with a relational DBMS.
Prerequisite(s): IS 301; IS 350; and must be declared into a business major or minor.
Units of Lecture: 3
Offered: Every Fall and Spring
Student Learning Outcomes:
Upon completion of this course:
1. Students will be able to design a database using the normilization process that is stable and understand why your design is stable.
2. Students will be able to use entity-relationship diagrams (ERD’s) to depict the design of a database.
3. Students will be able to use ERD’s to communicate design concepts with both technical and non-technical people.
4. Students will be able to use structured query language (SQL) to create, update, and access data in a database.
5. Students will be able to identify the objectives and design goals of a transaction database versus a data warehouse.
6. Students will be able to describe the general components of a database management system.
7. Students will be able to describe the job activities that are the responsibilities of a database administrator.
Click here for course scheduling information. | Check course textbook information
|
|
|