Description of your registration system: describe the system in words and how it should behave.

In this project, you are to design and implement an Oracle database system for a university
registration system where students register their courses for different semesters. Different tables,
relations, and column parameters can exist in such a system. Refer to the following two papers
where two different registration systems were addressed. Each group design is expected to be
different from other groups. Implementation of your design includes inserting sound data into
tables and showing how a student is selected and courses are offered to her/him based on what
courses that are available and unavailable (e.g., a student might have already taken a course).
[1] Jun Yan, Yun Yang and G. K. Raikundalia, “SwinDeW-a p2p-based decentralized workflow
management system,” in IEEE Transactions on Systems, Man, and Cybernetics – Part A: Systems
and Humans, vol. 36, no. 5, pp. 922-935, Sept. 2006.
[2] Jarrah, M, Al-khatieb, B, Mahasneh, N, Al-khateeb, B, Jararweh, Y. GDBApex: A graphbased system to enable efficient transformation of enterprise infrastructures. Software: Practice
and Experience, 2021; 51: 517– 531. https://doi.org/10.1002/spe.2871
Figures: Your final report should include figures to illustrate your table/relations design. Each
Figure must have a number and caption.
Tables: You might need tables in your report. If so, each table must have a number and caption.
Length of your report: It should be between 6-10 pages, one column. Font type Times New
Roman, 12 font size (body text) and 14 for headings.
At least, your report should include the following components:
1. Description of your registration system: describe the system in words and how it should
behave.
2. Database design: Based on the description above, design the different tables, relations,
and table column names.
3. Implementation: Use Oracle 19c software to implement your design.
4. System at work: In this section, provide screenshots of SQL queries to prove that your
database system is working according to the behavior that was put in the system
description.