Assignment Task
Learning Outcomes Assessed – This coursework assesses:
LO 1: Design, Implement and Critically Evaluate a Database Student Feedback Database
Scenario
You have been assigned to create a student feedback database for a university.
The requirements are that:
• The database should accommodate all relevant data without loss of information.
• The database should follow the principles of relational database design. In particular, all tables should be in third normal form. A comprehensive set of integrity and domain constraints should be applied.
• The database should be populated with all of the sample data given below.
• To add functionality to the database, a few SQL queries need to be written. Detailed requirements for these are given below.
• A procedure is also required. Detailed requirements for the procedure are given below.
Data Description and Sample Data
Modules are identified by a unique alphanumeric code of six characters. Lecturers have a unique staff number consisting of ‘L’ followed by four digits. Students have a unique student number consisting of ‘M’ followed by five digits. Ratings are integers in the range 1-5.
In any session, a single lecturer teaches each module, but the lecturer may change from session to session. Each session, students are required to give a numerical rating and textual comments on the modules they have attended. Textual comments are limited to a maximum of 1000 characters.
Task 1 – Creating Your Database
Write an SQL Script that runs without error and creates the required database. Your database should be called Feedback
A good design will have multiple tables. Table names should be a good description of the entities they contain. Column names should be descriptive, but need not match those given above. In particular, they should not contain spaces. For example, you cannot call a column ‘Module Code’, but you can call it ‘Modulecode’. The script should be a plain text file. This is the type of file that SQL Server Studio creates when you save your work. The file must be called Create.sql.
Task 2 – Populating the Database
Write an SQL Script that inserts the sample data into your database. The script should run without error and all the data should be added. You should not insert additional records, but you should include values for any primary keys that you have added. The script should be a plain text file. The file must be called Populate.sql.
Task 3 – Test Queries
Write an SQL Script containing the three required queries. Running the queries on your database should return the required data. The queries should work for general data, not just for the test data. The script should be a plain text file. The file must be called Queries.sql.
This IT Assignment has been solved by our IT experts at Schooling Best. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
