Logical Structure of IS 441 Course Roadmap
Explore the logical structure of the IS 441 course through understanding business processes, data modeling, database design, SQL, and advanced topics. Dive into important points like ERD, relational modeling, and advanced SQL concepts.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
CHAPTER 0: ROADMAP TO IS 441 - BRING TO EVERY CLASS AS A USEFUL REMINDER AND CHECKLIST Dr. Y e Jeff Zhang Dr. Y e Jeff Zhang California State University, Northridge California State University, Northridge First created July 2019 for Summer 2019 class First created July 2019 for Summer 2019 class
ROADMAP LOGICAL STRUCTURE OF THE COURSE 1. Understanding of Objects in the system that we want to model and store information about Business processes 2. Representation of the above under- standing in a structured manner 3. Preparation of 2 for database implementation; checking for errors and improving the design 4. Implementation: Coding 5. 1 leads to 2 ; 2 and 3 must be consistent Chap 2: Modeling Data Chap 2: Modeling Data in the Organization the Organization (E (E- -R modeling) R modeling) in Chap 3: Enhanced E Chap 3: Enhanced E- -R R modeling modeling Chap 4: Logical Database Chap 4: Logical Database Design and Relational Data Design and Relational Data Model Model Chap 5: Intro to SQL Chap 5: Intro to SQL Chap 6: Advanced Chap 6: Advanced SQL SQL 0-2 Chapter 0 - Roadmap
DIFFICULT OR IMPORTANT POINTS Chap 2 (ERD) Difference between degree and cardinality Associative entity: how to determine cardinality Unary relationship Chap 4 (Relational modeling) Mapping unary and 1-1 relationships Functional dependency - analytical observation Normalization: concept, procedure Chap 5 (Intro SQL) Structure of SELECT-clause (***) GROUP BY Deadly sin : mistaken for ORDER BY Difference between WHERE- and HAVING-conditions 0-3 Chapter 0 - Roadmap
DIFFICULT OR IMPORTANT POINTS (CONTD) Chap 6 (Adv SQL) Multi-table join Outer join: concept; avoid abuse Self join: correct identification of PK and FK Subquery Relationship between main/outer and sub/inner queries *** Correlated subquery 0-4 Chapter 0 - Roadmap
