• California State University, Fullerton

• CPSC 332

Course Syllabus CPSC 332 – 05 (14027) File Structures and Database Systems Term: Spring, 2021 Course Title: File Structures and Database Systems Professor: Chun-I Philip Chen, Ph.D. (310)561-9265 [email protected] California State University, Fullerton Department of Computer Science Office: CS Department, Office Hour: Monday, 6:30 pm – 7:00 pm. Please make an appointment in advance by email. Course Title: File Structures and Database Systems Course Number: 332 – 05 (14027) Class Schedule: Monday: 7:00 pm – 9:45 pm Classroom Location: Web Online (Zoom Meetings) Course description; This course covers the following topics; Database Design Theory and Normalization process, File structure, Indexing and Hashing, Query processing & Optimization, Transaction processing concepts and theory, Concurrency control & recovery, Database backup and recovery, Database performance design considerations, NonRDBMS (NoSQL), Data Warehouse and Business Intelligence, Big Data and Data mining concepts. Course Objectives; Goals  To provide the theory needed in understanding database management, database design, and their applications. Design and normalization principles for relational databases  To introduce the concepts, notations and techniques of relational database, Structural Query Language (SQL), conceptual modeling, integrity and normalization, physical storage and optimization, query and transaction processing.  To introduce the concepts, notations, and techniques of storing and retrieving information in the secondary storage, using object oriented design methodology. This study source was downloaded by 100000874968972 from CourseHero.com on 04-05-2024 04:09:37 GMT -05:00 https://www.coursehero.com/file/83601319/CPSC-332-05-File-Structure-and-Data-Base-Syllabuspdf/  To teach the basic skills of manipulating record files, including searching, sorting, indexing, and hashing.  To teach database design from the reality. You will learn how to design a database, starting from the real world, to the conceptual model, to the relational model, and then finally to the underlying tables. You will also learn how to fine tune your design to a better one. Upon completion of this course, student should be familiar with the following: 1. Understand and create relational data models utilizing entity-relationship. 2. Design and normalization principles for relational databases, including the various normal forms. 3. Underlying file structures used to implement databases, and their performance implications. 4. Multi-user database concerns such as crash recovery, concurrency control, security, and integrity. 5. Understand relational data model in terms of data structure, data integrity, and data manipulation. 6. Complete a database project that could be applied to the real world applications in a team project environment