91福利社

Database Systems — ISTC 1050

1. Course Description
   • Credits: 3.00
   • Lecture Hours/Week: 2.00
   • Lab Hours/Week: 2.00
   • OJT Hours/Week: 0
   • Prerequisites:
     • ISTC 1015: Supporting Business Applications
   • Corequisites: None
   • MnTC Goals: None
   This course focuses on the fundamentals of relational databases; their use, design and implementation. The course will include entity-relationship modeling, logical and physical design and normalization. The use of Structured Query Language (SQL) for data manipulation will be emphasized. The course will also cover concepts of client/server, distributed and object-oriented databases, big data security, and data warehousing. Prerequisites: ISTC1015 Supporting Business Applications
2. Course Effective Dates: 8/20/07 – Present
3. Outline of Major Content Areas
   As noted on course syllabus
4. Learning Outcomes
   1. Design relational databases according to normalization practices, annotating the design in Entity-Relationship diagrams.
   2. Utilize SQL commands for data definition, data retrieval, and data manipulation in single and multiple table environments.
   3. Summarize database administration concepts of concurrency control, locking and recovery strategies.
   4. Explain various database science concepts such as big data, NoSQL databases, and data warehousing.
5. Minnesota Transfer Curriculum Goal Area(s) and Competencies
   
6. Learner Outcomes Assessment
   As noted on course syllabus
7. Special Information
   None noted