|
|
|
May 20, 2024
|
|
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 ; 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
Add to Portfolio (opens a new window)
|
|
|