Course Description
Required for B. S. degree in computer science, and a Minor in Management Information Systems (MIS)
This course provides an introduction to the logical and physical structures of computer database systems. Topics include data models, query languages, relational database design, database constraints, and file structure. Students will be required to complete a project involving database design and implementation.
Prerequisites: CSCI 202 or CSCI 216
Course Objectives
Textbooks
Required:
Modern Database Management
Jeffrey A. Hoffer, V. Ramesh and Heikki Topi
(Eleventh Edition), Prentice Hall, 2011
Reference:
Database Security
Alfred Basta and Melissa Zgola
Cengage Learning, 2012
Fundamentals of Database Systems
Elmasari and Navathe
Seventh Edition, Pearson 2016
Also: Course Notes and Handouts
Required for B. S. degree in computer science, and a Minor in Management Information Systems (MIS)
This course provides an introduction to the logical and physical structures of computer database systems. Topics include data models, query languages, relational database design, database constraints, and file structure. Students will be required to complete a project involving database design and implementation.
Prerequisites: CSCI 202 or CSCI 216
Course Objectives
- Understand the conceptual, logical, and physical models of relational databases
- Apply the concepts of keys, foreign keys, and referential integrity
- Be able to write SQL statements to create, query, and update a relational database
- Have experience in the design and implementation of relational databases
- Understand and implement database security issues.
- Understand database security models
- Learn about alternatives for relational databases – flat, network, object-based, object-oriented, and NoSQL
- Learn about common database vulnerabilities, especially SQL Injections.
Textbooks
Required:
Modern Database Management
Jeffrey A. Hoffer, V. Ramesh and Heikki Topi
(Eleventh Edition), Prentice Hall, 2011
Reference:
Database Security
Alfred Basta and Melissa Zgola
Cengage Learning, 2012
Fundamentals of Database Systems
Elmasari and Navathe
Seventh Edition, Pearson 2016
Also: Course Notes and Handouts
Syllabus: |
|