Ask a question from expert

Ask now

Southern Cross University Employees, Location, Alumni

Design and develop a relational database based on a fictitious scenario, including normalisation, supertypes and subtypes, and relational joins.

11 Pages1157 Words17 Views
   

Added on  2022-08-13

About This Document

http://infotech.scu.edu.au/phpMyAdmin/index.php Please use this link provided in order to build the database Username: gmoram10 Password:********3 I just need to focus on Part B – Database Prototype – due Week 13 once you logged in build the database on this one: gmoram10Ass3.

Southern Cross University Employees, Location, Alumni

Design and develop a relational database based on a fictitious scenario, including normalisation, supertypes and subtypes, and relational joins.

   Added on 2022-08-13

BookmarkShareRelated Documents
SOUTHERN CROSS UNIVERSITY
ASSIGNMENT COVER SHEET
For use with online submission of assignments
Please complete all of the following details and then make this sheet the first page of each file
of your assignment – do not send it as a separate document.
Your assignments must be submitted as either Word documents, text documents with .rtf
extension or as .pdf documents. If you wish to submit in any other file format please discuss
this with your lecturer well before the assignment submission date.
Student Name:
Student ID No.:
Unit Name: Database Systems
Unit Code: CSC72001
Tutor’s name:
Assignment No.: Assessment 3
Assignment Title:
Due date:
Date submitted:
Declaration:
I have read and understand the Rules Relating to Awards (Rule 3 Section 18 –
Academic Misconduct Including Plagiarism) as contained in the SCU Policy
Library. I understand the penalties that apply for plagiarism and agree to be bound
by these rules. The work I am submitting electronically is entirely my own work.
Signed:
(please type
your name)
Date:
<Student name and ID> CSC72001 Assessment 3 Report Page 1
Southern Cross University Employees, Location, Alumni_1
ASSESSMENT 2
REPORT
BY <Insert your name>
<Student name and ID> CSC72001 Assessment 3 Report Page 2
Southern Cross University Employees, Location, Alumni_2
Table of contents:
Contents
Table of contents:....................................................................................................... 3
Enhanced Entity Relationship Diagram......................................................................4
Part B: Testing Queries............................................................................................... 5
Query 1
Club facilities........................................................................................... 5
Query 2
Members list for a class...........................................................................5
Query 3 Counting club members...........................................................................6
Query 4 Personal trainers...................................................................................... 7
Query 5 Information about club managers............................................................8
Query 6 Trainers specialised in weight loss..........................................................8
Query 7 Members statistic.................................................................................... 9
Query 8 Club timetable....................................................................................... 10
<Student name and ID> CSC72001 Assessment 3 Report Page 3
Southern Cross University Employees, Location, Alumni_3
Enhanced Entity Relationship Diagram
<Student name and ID> CSC72001 Assessment 3 Report Page 4
Southern Cross University Employees, Location, Alumni_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Prototype Designs
|17
|1005
|25

DTB91001 Data Management Systems Assignment 3 2022
|10
|1420
|42

South Central Cross UNIVERSITY ASSIGNMENT COVER SHEET FOR Online Submission
|6
|616
|266

Southern Cross University Assignment 2022
|11
|1290
|16

Analysis Client Business Rules
|8
|737
|23

Southern Cross University Report
|5
|542
|8