CIS 310 Database Design
This course provides a solid and practical foundation for the design and implementation of database systems. Emphasis is on relational database models, with significant coverage of basic relational database concepts, normalization, E-R modeling, locking, SQL, and distributed databases. The software used for this course was Microsoft SQL Server. This section show SQL queries built using example databases in the course.
Assignment 6
Is the first example of building SQL queries for a database to build reports. The table data is also included in this assignment.
Assignment 7
More advanced SQL queries. This assignment used a Bike Shop database as created queries based off of real world applications.
Assignment 8
An exercise in creating update triggers. This trigger updates a movie rental company database.
Assignment 9
A database setup involving adding primary key constraints and foreign key constraints. The queries are set up in such a way that each table will be created in sequence so that database integrity is maintained.
Assignment 10
An exercise is creating and populating a star schema database for data warehousing. The tables are first built using assignment 9 generating a resulting ERD. Then the star schema database is populated and a pair of test queries are run to show the results.