In this case study, you and your team members are asked to design and implement the database component of a software system that could be used by a Registrar's Office of a College. The various screens of the systems are shown in the screen mockups in the Appendix below.

More specifically, your tasks are:

$1.$ Design all the necessary tables where all the relevant data can be efficiently stored

$2.$ Write all the SQL code to support the application

Pay attention to the following requirements:

$$ A course might be offered in multiple sections $($Note that on the mockups, a Section is called a $$Course Offering$$ They are just synonyms$).$

$$ A course $($eg DBAS$27198)$ can be offerred in multiple sections $($eg$.,1145\_24828,1145\_24123,$ etc.$).$ Each section is associated with a specific semester $($e$.$g$.$ Fall $2013,$ Winter $2014),$ and an instructor.

$$ Students are registered with a Section, never with a course.

$$ You must write the SQL code to create courses, sections, and add students to course.

$$ You must also write the SQL queries to pull the data from the various tables into the grid formats shown on the mockup pages. $($Please note that you might have to join or sub$-$query your tables together to produce the grids exactly as shown.$)$

Please feel free to approach the instructor and clarify anything that is unclear about this case study.

Remember to treat this case study as a learning challenge and not just a $$burden$$ that you need to get over with. You will learn a lot of useful skills from this project if you treat it as a learning opportunity.

Have fun!

Appendix: Screen Mockups

provide screenshots of the Dashboard working