2021-2022 Catalog [ARCHIVED CATALOG]
|
CSCI 210 - Database Systems
PREREQUISITES/COREQUISITE: CSCI 105 - Discrete Logic for Computers .
PROGRAM: Computer Science
CREDIT HOURS: 3
TOTAL CONTACT HOURS: 3
DATE OF LAST REVISION: Fall 2020
The course presents the theory and practice of database systems and gives an advanced introduction into the concepts for modeling, designing, querying, and managing large and distributed databases. The emphasis will be on theoretical considerations involved in modeling data and the principles of database systems in a multi-user environment. Students will address issues associated with enterprise database processing with respect to user authentication and development in an application/internet environment.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of the course, the student will be expected to:
- Differentiate the use of a database from the approach of programming with data files
- Explain the concept of data independence and its importance in a database system.
- Differentiate between object-oriented, relational and other database models (structured and unstructured).
- Select, develop and evaluate the appropriate enterprise database architecture based on the requirements of an organization.
- Identify data integrity and security requirements including access control, least privilege, and database/data encryption.
- Demonstrate an understanding of user needs assessment for existing and future information needs
- Apply normalization techniques (e.g. E. F. Codd).
- Develop a logical/conceptual data model, including all entities, relationships, and attributes from business rules and requirements.
- Derive a physical design from the logical design in view of application, hardware, operating system, and network requirements.
- Implement user authentication, privileges and roles for major DBMSs.
- Process a database via SQL and application programs.
- Develop programs that interface with a database, implementing the insertion, retrieval, and updating of data.
- Assess data mining, data warehouse, and OLAP cube concepts in support of all management levels.
- Describe the advantages and disadvantages of central organizational control over data
- Explore distributed database design methods, heuristics, and design tradeoffs.
- Examine issues related to query execution, including optimization, transaction management, and fault tolerance.
- Investigate vulnerabilities and failure scenarios in database systems.
- Discuss ethical and privacy issues associated with database systems
COURSE CONTENT: Topical areas of study include - Business intelligence, data warehousing and mining
Entity Relationship (ER) Modeling
Data Integrity
Knowledge management
Database administration
Object-oriented database
Database backup and recovery
OLAP Cube and database processing principles
Database connectivity
Performance measurement techniques
Database design and normalization
Performance tuning and query optimization
Database Security
Structured query language (SQL)
Database systems and data models
Structured/Unstructured Data
Distributed database & multi-user management systems
Transaction management and concurrency control
DML/DDL/DCL
XML/JSON Schema
Course Addendum - Syllabus (Click to expand)
|
