Problem
Task I: A relational model showing all fields, primary keys, foreign keys and concatenated keys. Your relational model should be in third normal form. List any assumptions/business rules you have made.
Task II: A sample dummy input screen of scheduling an interview for one of the shortlisted candidates. You have to make sure all the data requirements are being captured.
You may use any tool you like to create this sample screen. Write a brief paragraph of about 200 words discussing the following
i. Does your database design allow the storage of all the required information?
ii. What changes, ifany, did you make to your initial ER diagram and relational model after you created the sample input screen?