Database Modeling Concepts
Database Modeling Concepts
Database models: relational, deductive, object-oriented. Integrity constraints, query languages, database design.
Hours | 3.0 Credit, 3.0 Lecture, 0.0 Lab |
Prerequisites | C S 240 |
Note | Students are allowed only 1 retake of C S 452. This includes students who have failed or withdrawn (received a "W" grade). If after 1 retake, a student needs to retake the course again, the student must wait 1 semester/term before being allowed to take any C S course and must follow the petition process at cs.byu.edu/retake-policy. This policy does not apply to classes dropped before the add/drop deadline. Petitions for exceptions to the policy can be completed at cs.byu.edu/retake-policy. |
Taught | |
Programs | Containing C S 452 |
Course Outcomes:
Query Languages
Be able to use a variety of commercial query languages (SQL, XQuery, SPARQL), both stand-alone and embeded in high-level programming languages. Know how relational algebra and relational calculus provide a basis for commercial query languages.
Query Optimization
Understand performance issues and optimization strategies. This includes query rewriting, secondary storage characteristics, and access strategies.
Database Design
Be able to design and develop relational database applications. This includes conceptual modeling and normalization theory.
Current Challenges
Be familiar with some of the current challenges facing database professionals.