This course examines data structures, file!organizations, concepts and principles of database management systems (DBMS); as well as, data analysis, database design, data modeling, database management and database implementation. More specifically, it introduces hierarchical, network and relational data models; entity?relationship modeling; the Structured Query Language (SQL); data normalization; and database design. Using Microsoft’s SQL Server and Microsoft Office Access DBMSs as implementation vehicles, this course provides hands?on experience in database design and implementation through assignments and lab exercises. Advanced database concepts such as transaction management and concurrency control, distributed databases, multi-tier client/server architectures and Web?based database applications are also introduced.
Like any introductory class, we will be exploring a wide array of topics, rather than a detailed drill-down. It is the primary objective of this class to expose you to the various ideas of databases and database design, with a major focus on the relational model and SQL (Structured Query Language). With that in mind, the outcomes of this course are to:
- Describe fundamental data and database concepts
- Compare and contrast the relational database model with other database models
- Explain and use database development lifecyce
- Design databases using data modelling and data normalization techniques
- create databases using popular database management system products
- solve problems by constructing database queries using the structured Query language (SQL)
- Develop insights into future data management tool and technique trends
- Recommend and justify strategies for for managing data security , privacy , audit/control, fraud detection, backup and recovery
- Critique the effectiveness of Database Management Systems in computer information systems
- become proficient at modeling databases at conceptual and logical levels of design,
- be able to develop database schemas with principled design that enforce data integrity,
- become knowledgeable in the creation, altering, and manipulation of tables, indexes, and views using relational algebra and SQL,
- become proficient at casting queries in SQL,
- and at writing database application programs with an understanding of transaction management, concurrency control, and crash recovery.
Course sessions may include lecture, demonstration, supervised hands-on projects, and independent problem solving sessions, online web-based learning and student presentations. Delivery of course materials, assignments, and tests will vary from course to course based on in-class and on-line course types. Students should expect that work outside of class is a requirement to complete the assignments.
- Operating Systems
- Microsoft Office Access
- Microsoft SQL database
- SQL Management tool
- SQL Manager
- Oracle database
- MYSQL database
- XAMPP/ WAMP
- Microsoft Visual Studio
- Database Management Systems by Raghu Ramakrishnan & Johannes Gehrke
- SQL for Smarties: Advanced SQL Programming by Joe Celko,
- Database Systems:The Complete Book by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom
- Database Systems: Design, Implementation and management by Carlos Coronel, Steven Morris
- Database Systems: A Practical Approach to Design, Implementation and management by Thomas Connolly, Carolyn Begg
- Modern Database Management by Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
To read the full syllabus for this subject, please download the document in the download section below.