The final project in this class will give you the opportunity to design and implement a moderately large database system in a domain of interest of you.
Rather than specifying one fixed domain/task specification that the entire class must address, groups will be able to select a domain/task particularly relevant to their outside interests, such as an investment portfolio database, a medical database, an astronomy database, a pharmaceutical database or a small business database
The project consists of three phases as shown below:
Who are the team members?
Briefly describe your target domain.
Give a reasonably comprehensive and representative list of the English questions you would like your system to be able to answer. Which includes all topics that we have covered in the course(Minimum 10)
For example, “Compute the average rate for countries with a per capita income of less than $400/year, grouped by continent.”
Design the database architecture in 3rd normal form showing the different types of dependencies.
The final phase will include the full implementation of each of the points proposed or described in phase 1 and phase 2 including a full suite of SQL queries to answer interesting questions in the domain.