INFO6001: Physical Database Design- Electrical Engineering & Computing Assignment

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Added on: 0000-00-00 00:00:00Order Code: Question Task Id: 0

MAS7617
Electrical Engineering & Computing Assignment:

Task:

In this assignment, steps in the physical database design are conducted (as described below) as well revising the concept database design and logic database design of assignment 1 and assignment 2. Also, a final report of the project is written.

This assignment has 3 parts as specified below.
1. Revise the concept database design and logic database design, based on your revision and the feedback provided by your lecturer. i.e. do the following three steps:
1.1 Complete the conceptual database design, including Requirement Specification (including data requirements, transaction requirements and business rules), and EER Diagram and Data Dictionary.
1.2 Map the EER model to the relational model. Document the relational schema in DBDL
1.3 Normalize the relational schema to Boyce-Codd Normal Form (Point out what norm form each relation is in, do the normalisation if any relation is not already in BCNF.). The final normalised schema must be documented in DBDL.

2. Completed major steps in the physical database design
2.1 Write SQL scripts which create the normalised University X database. Save the script as CreateDB c.sql. Note that is your student number.

2.2 Write SQL statements satisfying the transaction requirements including the following:
2.2.1 Input proper data (as you consider legitimate) of at least three rows for every table. Save the script as InsertData-c.sql. Note that is your student number.
2.2.2 Implement the following queries (make sure to populate with enough and proper data into related tables so that non-void result is shown for each query. A query will be given zero mark if it has void output or no output).
Note: in the queries, the values of X, Y, and Z can be the corresponding values in your database. Save the script as Query-c.sql. Note that is your student number.

Q1 – Given a student name X, print the names of courses that the student has successfully completed. Print the course code and course name. A student has completed a course when s/he has obtained a final grade P, C,
D or HD for the course.

Q2 – Given a course name X, semester Y and year Z, print its timetable. That is, the details of all course offerings including: course code, course name, day of week, activity, start time, end time, campus, building and room numbers that the course is offered in.

Q3 – Room number 101 in CT building will be closed for refurbishment in trimester 1, 2018. To inform the affected students, we need to get the email addresses of the affected students. Find the student number and email address of students who have classes in Room 101 in CT building for Trimester 1, 2018.

3. Write a final report. The final report should include all the content of the above tasks, including all the SQL scripts.

The final report should include the following:
1. Requirement Specification (including data requirements, transaction requirements and business rules).
2. EER Diagram and Data Dictionary
3. Normalized Relational Schema in DBDL. Ensure that normalisation steps are shown.
4. SQL script which creates and inserts data to the University X database
5. SQL statements satisfying the transaction requirements

Uploaded By : admin
Posted on : April 09th, 2018
Downloads : 2

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services