Data Management Systems Assignment 1: Southern Cross University

Desklib provides solved assignments and past papers to help students succeed.

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.
Student Name:
Student ID No.:
Unit Name: Data Management Systems
Unit Code: DTB91001
Tutor’s name:
Assignment No.: Assignment 1
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> DTB91001 Assignment 1 Report Page 1

Assignment 1
REPORT
BY <Insert your name>
<Student name and ID> DTB91001 Assignment 1 Report Page 2

Table of contents:
Contents
Table of contents:...........................................................................................................................................3
Entity Relationship Diagram..........................................................................................................................4
Part A: Analysis.............................................................................................................................................5
1. Client Business Rules........................................................................................................................5
2. Assumptions Made.............................................................................................................................5
3. Naming Conventions.........................................................................................................................5
4. Data Types Chosen............................................................................................................................5
Part B: Testing Queries..................................................................................................................................6
B.6.1 Workshop Enrolment List..........................................................................................................6
B.6.2 Workshop Count List.................................................................................................................6
B.6.3 Student Transcripts....................................................................................................................6
B.6.4 Student Assessment Totals........................................................................................................6
<Student name and ID> DTB91001 Assignment 1 Report Page 3

Entity Relationship Diagram
DTB91001: Data Management Systems
Assignment 1: Entity Relationship Diagram (ERD) of a “Student Enrolment System”
<Student name and ID> DTB91001 Assignment 1 Report Page 4

Part A: Analysis
1. Client Business Rules-
Business rules are the rules which can be set up using the graphical interface. Rules are defined
dynamic entire forms and perform action without writing a single line of client side code (java
script).According to given scenario Sothern corn university is a university of Australia which
provides a variety of Bachelor and Master degree to the student studying internally across the
campuses. Client business rule helps to define the client side rules for this database model. Business
rules are two types.
1. Database Oriented
2. Application Oriented
Both types of business rule help to maintain over all the data integrity but they are differ and Oriented
rules impose the logical data .All the below mention rule is mention for the client sides.
 Display the error message- If specified condition is not met than this action display the
message like – there is some error or particular provided message will be display. For
example, if the data entered in a field (Phone number) does not validation criteria then
business rules help to display the error message to user and also restricted to enter the
value in Sothern Cross University’s database.
<Student name and ID> DTB91001 Assignment 1 Report Page 5

 Set Fields value- this field help in database to set the fields value which fulfils the
condition to meet the requirements. For example – if student from Australia is selected
country then the country’s dialling code would be auto-fill in number’s fields. This
business helps to minimize the workload.
 Set business required- this business rule help to change the requirements level of fields
on the basis of dynamic according to the condition. Field can be mandatory or non-
mandatory and vice versa.
 Set visibility- this fields help to show the fields visible or non-visible in the entire forms.
Admin have right to provide the visibility of field or also customization option according
to the requirements or condition
 Lock or unlock fields- this fields help to enables or disable (lock or unlock) fields
dynamically according to the requirements. Unlock fields can be edit or lock but lock
fields can be read only. For example - Student could enrolment and after enrolment,
student can be edit user name but can edit the name or other fields. At that case user is a
field which can be read only.
2. Assumptions Made
Database is based on assumption and assumption is only determined to be correct or faulty once the
database is built and tested. A wrong assumption does not create negative impact always on database;
it assists to find something or performing the query in database.
3. Naming Conventions
When database create by ERD, it should be necessary to focus on database elements and
also name all the elements like- table, views, columns, key (including all primary key,
foreign key and alternate keys) and Schemas etc. But don’t need out other element less-
visible items like – table space, constraints, references, indexes, sorted procedures,
triggers, sequences and variable.it should be necessary the knowledge of ,how to name.
There are rules which should be follow.
 Name can be choose between uppercase and lower case.
 Word should be separate by underscore ( _ ) like- ( st_name ).
 Use singular names, for example – use student not students.
4. Data Types Chosen
<Student name and ID> DTB91001 Assignment 1 Report Page 6

Figure 1: Assessment Table Design
Properties Property description Size
AssessmentID The assessment ID consists of the ID
of the particular assessment which is
having the Varchar datatype and is a
primary key.
45
UnitOfferingID The ID of the unitoffering consists of
the unique identification number.
45
AssessmentName Provides the Name of the
Assessment.
45
Description Provides the description of the data. 45
DueDate Gives the due date of the work. No length
PossibleMark The marks awarded to the student has
been inserted and it consists of the
integer datatype.
11
<Student name and ID> DTB91001 Assignment 1 Report Page 7

Figure 2: Course Table Design
Properties Property description Size
CourseName The name of the course
which the student has opted
is inserted and is having the
Varchar datatype.
45
CourseCode The code of the course
consists of the identity of
particular opted course which
is integer datatype.
11
Creditpoints The CreditPoints of the
student consists of the gained
credits. This consists of the
integer datatype.
11
Notes The notes consist of the data
of the course where the
students enrol.
45
Figure 3: Course_Enrolment Table Design
<Student name and ID> DTB91001 Assignment 1 Report Page 8

Properties Property Description Size
StudentID The student’s unique
identification number of the
student is the primary key
which is having the Integer
datatype.
11
CourseCode This field consists of the code
of the particular course which
is the unique identification
ID of the course and having
the integer datatype.
11
EnrolmentDate The date of the enrolment
consists of the date and time
of the student enrolment
which is having the date and
time datatype.
No length
status The status field consists of
the enrolment status of the
student which is having the
Varchar datatype.
45
Figure 4: Student Table Design
Properties Property description Size
<Student name and ID> DTB91001 Assignment 1 Report Page 9

StudentID This value consists of the integer data type
which displays the unique identification
information of the student.
11
Firstname This property consists of the Varchar
datatype which is used to insert the first
name of the student.
45
LastName This property consists of the Varchar
datatype which is used to insert the last
name of the student.
45
Address The address field is used to insert the
student address and consists of the Varchar
datatype.
45
City The city value is used to insert the city of
the student. Which consists of the Varchar
datatype.
45
State The state field is used to insert the student’s
state where he/she is living. It consists of
the Varchar datatype
45
Postcode This field used to insert the postcode of the
particular area where the student lives. It
consists of the integer datatype
11
Phone The phone field of the student consists of
the contact number of the student. It
consists of the integer datatype.
11
Email The email field consists of the email
addresses of the students which is in the
varchar datatype.
45s
<Student name and ID> DTB91001 Assignment 1 Report Page 10

Figure 5: Student_Assessment Table Design
Properties Property description Size
AssessmentID The assessment ID consists of the ID
of the particular assessment which is
having the Varchar datatype and is a
primary key.
45
StudentID The ID of the student consist of the
unique identification number of the
student which is a foreign key.
11
DateSubmitted The date on which the assessment is
submitted by the student. It consists
of the date and time datatype.
No length.
DaysExtension The days of extension provided to the
student is inserted which consists of
the integer data type.
11
MarkAwarded The marks awarded to the student has
been inserted and it consists of the
integer datatype
11
<Student name and ID> DTB91001 Assignment 1 Report Page 11

Figure 6: Teacher table design
Properties Property description Size
StaffID This field consists of the ID
of the staff to uniquely
identify them. This is the
primary key and having
integer datatype.
11
Firstname The first name field consists
of the first name of the staff
which is having the Varchar
datatype.
45
LastName This field consists of the last
name of the staff which is
having the Varchar datatype.
45
Campus The campus is the place
where the student studies and
it consist of the Varchar
datatype.
45
OfficLocation The office location consists
of the location of the office
for the staff. It consists of the
Varchar datatype
45
Phone The phone consists of the
phone number of the staff
11
<Student name and ID> DTB91001 Assignment 1 Report Page 12