Sample syllabus
Contents
CSC300: Spring 2020
Course Description
In this course, we will be covering basic principles of database management systems (DBMS) and of DBMS application development. DBMS objectives, systems architecture, database models with emphasis on Entity-Relationship and Relational models, data definition and manipulation languages, the Structured Query Language (SQL), database design, application development tools. 3 lectures, 1 laboratory. This course prepares you to as a database developer to gain an understanding of the place of databases in software development. We will learn the principles of data storage and retrieval and how this skill is used in business.
Course Instructor
My name is Allan Gitobu. I will be your instructor for this course. I am a PhD candidate at Claremont Graduate University. I also work as a software Engineer at a Pharmacy Benefits Management company in San Diego, CA. My research interest is in healthcare IT. I have about twenty years’ experience in software development especially in the area of software development. I have worked broadly in system design and mobile application development for IOS.
Contact Information
Office: ACB 999
Phone:858 231 5809
E-mail: allan.mugambi@cgu.edu
In-person Office Hours: M, T 9:00 AM to 10:30 AM
Phone/Skype Hours by appointment: Skype address allangitobu
Learning Outcomes - Destinations for Your Learning Journey
Course Goals
Have you ever considered that you access and manipulate data on a database almost every time you do anything on a mobile phone? Looking up a contact or creating a new one on the phone is a database manipulation activity. Yet many people will respond that they have never used a database. Businesses run on data, so that places those who manage data or control its access at a central and important place in data management. In this class, we will learn how to exercise control over data and position ourselves as ones with absolute authority with how businesses are to access and use data. Much of what we do in computer information system revolves around how to acquire, store, and retrieve data. We are in charge.
Learning Outcomes
In successfully completing this course, you will be able to:
- Design a database system framework showing how computer systems store data.
- Demonstrate and understanding of entity-relationship models in database design.
- Illustrate how to create a database on a relational database management system (RDMS)
- Demonstrate knowledge of retrieving data from a database using structured query language (SQL)
CAPACITY DEVELOPMENT OUTCOMES
In addition to mastery subject matter, you will be able to:
- Work in a team to develop a business-class database.
- Demonstrate the value of the database design to a business use.
- Communicate orally and in writing to both academic and non-academic audiences.
MID-TERM OR END OF COURSE REFLECTION
Part way through the class, we will reflect on how you are moving toward these outcomes or goals. What have you enjoyed? What have you most struggled with (this can be the same as the things you enjoyed!), and how are you working to help yourself succeed? How can I help you? You will post these reflections on the discussion board on the Canvas.
Course Texts & Resources
Required:
BOOK: Vidhya, V., et al. Database Management Systems, Alpha Science International, 2016. ProQuest Ebook Central
https://ebookcentral.proquest.com/lib/claremont/detail.action?docID=5248352.
You may access this book as an e-book from the university library
Course Outline
| Date | Topic | Reference |
|---|---|---|
| January 7, 2020 | Introduction to DBMS, File processing systems, database systems structure | Vidhya et al (2016) chapter 1 |
| January 14, 2020 | Introduction to data models | Vidhya et al (2016) chapter 2 |
| January 21, 2020 | Relational Algebra, basic operations, relational calculus | Vidhya et al (2016) chapter 3 |
| February 4, 2020 | SQL fundamentals | Vidhya et al (2016) chapter 4 |
| February 11, 2010 | Joins, constraints, and advanced SQL | Vidhya et al (2016) chapter 5 |
| February 18, 2020 | Mid-term exam and project presentation | |
| February 25, 2010 | Relational database design | Vidhya et al (2016) chapter 6 |
| March 3, 2020 | Transactional processing | Vidhya et al (2016) chapter 7 |
| March 10, 2020 | Query processing | Vidhya et al (2016) chapter 13 |
| March 17, 2020 | PL/SQL | Vidhya et al (2016) chapter 14 |
| March 24, 2020 | Final project presentations | |
| March 31, 2020 | Final exam |
