Database Management Systems CMPT 391 Winter 2020 Project Part I : Weight : 70% of total project weight. (Project weight is 35% of total course mark) Introduction You will demonstrate your mastery of the material taught in this course with a multi-phased, individual-based term project. In this project, you will design and implement a relational database system to support the operations of a College Database system. If you own a PC, you are encouraged to develop as much of the code as possible on your PC. Getting Started A college contains many departments. Each department can offer any number of courses. Many instructors can work in a department, but an instructor can work only in one department. For each department, there is a head, and an instructor can be head of only one department. Each instructor can take any number of courses, and a course can be taken by only one instructor. A student can enroll for any number of courses and each course can have any number of students. Documentation You will be required to supplement your completed database implementation with a design document that contains information concerning your design criteria and decisions. The following is a list of some of the information you should include: • Entity-Relationship (E-R) Diagram of the complete database scheme • Lucid description of the relational database scheme for your system, including a discussion of the reasoning behind your design decisions. Make clear how your design supports efficient query processing. • Screen Mock-ups of your system. • Brief description of the business rules of your system Assumptions and dependencies: • The software package is to be developed using VB.Net or C#.Net as front end and Microsoft SQL server as the back end. • Groups are made up of three students only. • The system will be built with the assumption that many users can access it at the same time. • Metalized views should be used at the database level. • Stored Procedures should be implemented at the database level • Transactions should be used when accessing the databases, and full rollback mechanism should be supported. Submission In order to evaluate your final system, you will be asked to present a short (15-20 minutes) demo in the last week of classes. This project will be made of Three main phases. Each phase has one or more marked homework. The three major phases of the system will be: 1. School registration system (70%) Deadline: March 12th, 2020 2. Data warehouse system (20%) Deadline: March 19th, 2020 3. XML data upload System (10%) Deadline: April 2nd, 2020 The overall project is worth 35% of your final grade. Details for phase 2 and 3 of your project will be released around mid February.
