file-based database design
as soon as possible
MIS602 Assign1 Page 1 of 3
ASSESSMENT BRIEF
Subject Code and Name MIS602 Data Modelling & Database Design
Assessment One – Peer Assessment of File-based Database Design
Individual/Group Individual
Length See below for details
Learning Outcomes B
Submission Thursday 11:59 PM AEST/AEDT of Module 2 (week 4)
Sunday 11:59 PM AEST/AEDT of Module 2 (week 4)
Weighting 25%
Total Marks 25 marks
Context:
The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to
your understanding of data and database management and its relevance with in business context. It
also introduces you to some of the key features of database management system and designing
database systems that will feature in later modules of this topic. In order for you to do well in this
subject, it is imperative that you undertake all of the learning activities in the modules. The learning
activities are presented as a way of scaffolding your learning so that you can attempt the building
blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore,
doing your learning activities and seeking feedback from them from peers and from the learning
facilitator is the single best way of preparing for doing well in this assessment.
Instructions:
There is an imperative requirement in this assessment; you must submit different versions of the
files by Thursday of week 4 at midnight (Sydney time). The files should ideally be of excel format.
The data in the files should be composed based on the following scenario:
Torrens University Australia (TUA) is interested in a new Student record management
system. This system needs a database to manage students enrolled, courses students
enrolled in and staff facilitating the course. You will need to store and manage the data for
the enrolled students, courses and the staff assigned to the courses. The system is intended
to be built in-house. The university has a very strong information systems suite of programs
and the students of that program are showing great insight and promise. It has signalled its
intention to seek input from those students in a consulting arrangement.
MIS602 Assign1 Page 2 of 3
The system should allow the staff to add, update and delete the records of students, staff
allocated to course and courses. In addition, University staff should be able to see the list of
students enrolled in a particular course facilitated by a particular learning facilitator.
Based on this scenario, you should identify key data objects and their attributes and define them as
columns in the spreadsheet. Create multiple versions of the spreadsheet file as per below
instruction:
• Version 1 (V1.0) with all possible database objects and attributes and create 30 rows of data.
• Version 2 (V1.1) of the file should update last 2 records and add 5 additional records
• Version 3 (V1.2) of the file should add 2 new attributes
• Version 4 (V1.3) of the file should remove 5 existing attribute and add 5 more rows of data
When you are finished this, combine the four versions of the Excel database solution with a
document that in more than 1000 words, describing your experience. On the morning following
submission, the learning facilitator will allocate you another student’s spreadsheets and summary
document to assess. It is then your turn to assess another student’s work. You will have three days
to assess the other student’s work and to upload your response to Blackboard.
In no more than 500 words, provide a critique of that student’s work to them. You can choose
whether to identify yourself but you should provide constructive feedback, balancing good points
and points where the student can improve. You should use the scenario and provide feedback to
the other student on their list of data objects, data attributes and summary document. You are free
to use whatever framework you like and the following should be minimum inclusions:
• Comment on the overall suitability of the data objects and attributes as an input for
database design and the summary document
• Provide constructive criticism on how the other student can improve their data objects and
attributes in future
• Provide some useful readings the other student may peruse that helps them develop their
understanding of data and data attributes
Submission Instructions:
Your spreadsheets and summary should be submitted by Thursday at midnight (Sydney time) of
week 4. Do not include any identifying information on your submission (i.e. not your student
number, name or anything else that might identify you). This is important because the peer review
is to be done anonymously. Non-submission or lateness will be treated in accordance with the late
assessment policy of the university.
Please note that late submissions mean that another student will effectively have less time to do
their peer assessment of your work.
MIS602 Assign1 Page 3 of 3
Learning Rubric: Assessment One
Assessment Criteria
Fail
(Unacceptable)
0-49%
Pass
(Functional)
50-64%
Credit
(Proficient)
65-74%
Distinction
(Advanced)
75 -84%
High Distinction
(Exceptional)
85-100%
Understanding of the
Data and Data
attributes
30%
Demonstrates limited
understanding of Data
and Data attributes.
Fair understanding of Data
and Data attributes
demonstrated. May
neglect to provide
resources or that these are
cursorily provided without
reference to specific areas
in the source.
Good understanding of
Data and Data attributes
demonstrated. May
provide a limited
number of sources the
peer can use to develop
their technique from.
Very good understanding of
Data and Data attributes
demonstrated. Makes
recommendations to other
external sources the peer can
access to develop their
understanding.
Outstanding understanding of
Data and Data attributes
demonstrated through
recommendation of other
sources with specific
references to components of
it that the peer will benefit
from.
Application and
Evaluation of the File
based database
management system
40%
Limited understanding of
the database
management system and
its applicability to
organization.
Understands the context
and impact the database
management system in an
organization and provides a
critique for the peer.
Understands the context
and impact the database
management system in
an organization.
Identifies logical flows
and questions the
viewpoints of the peer.
Evaluates the database
management system,
providing a critique of the
peer’s work, relevant to the
scenario. Identifies logical
flows and presents
suggestions the peer can use
to develop their technique.
Expertly evaluates the
database management
system presented by the peer.
Provides a thoughtful critique
in the context of the scenario
that the peer can use and
genuinely develop from.
Effective
communication
30%
Difficult to understand for
audience, no logical/clear
structure, poor flow of
ideas, argument lacks
supporting evidence.
Audience cannot follow
the line of reasoning.
Information, arguments and
evidence are presented in a
way that is not always clear
and logical. Line of
reasoning is often difficult
to follow.
Information, arguments
and evidence are well
presented, mostly clear
flow of ideas and
arguments. Line of
reasoning is easy to
follow.
Information, arguments and
evidence are very well
presented; the presentation is
logical, clear and well
supported by evidence.
Demonstrates cultural
sensitivity.
Expertly presented; the
presentation is logical,
persuasive, and well
supported by evidence,
demonstrating a clear flow of
ideas and arguments. Engages
and sustains audience’s
interest in the topic,
demonstrates high levels of
cultural sensitivity.
Assessment 1_602/ERD- ENTITY RELATIONSHIP DIASRAM (1)
Assessment 1_602/REPORT_ASSESSMENT_1 x
ASSESSMENT 1 MIS604
DATABASE MODELLING AND DATABASE DESIGNING
REPORT ON DATABASE OF THE TORRENS UNIVERSITY AUSTRALIA
Data is known as the facts or information that we are using every day for carrying our services. Whereas database is the collection of those facts or information and is found in an appropriate organized manner. Now when we are arranging our data or facts into a form of tables with rows and columns this process is known as the data modelling.
So, first of all, when I have started collecting the data about Torrens University, I have first draw ERD diagram, the major reason behind this was to get an idea about the relationship between the objects and their attributes. Thus, I have found that there are 4 main entities in this database, the University, Student, Course and Lecturer. Similarly, there are several attributes linked to these mentioned entities, such as, Student id, First name, Last name, Course Id, Course name, Lecturer name and so on. This is also known as a data modelling. Thus, drawing a diagram was an easy task, however, finding a relationship between them was a little tricky.
So, I have used crow’s notation to demonstrate their relationship and have used the bridge as well. Further up, now it is a time to put all the data into the table form into the excel spreadsheet. When I have started, I found it easy to distribute the data into rows and columns. I have used three different tables for each entity, student, course and lecturer.
The major reasoning using three different tables to avoid the mixing of data and further complexities. I have used, student Id, course id and lecturer Id as the primary keys to demonstrate the value of the all other related attributes. Also, there is a composite key that I have used to prevent data anomalies, which is a combination of Student ID and First Name. Moving further, in version one and two everything was going smoothly, I have deleted two rows easily followed by the addition of the 5 new rows, under those same attributes. So far, I did not face much issue.
However, the problem comes up when I moved to version 3, where I have to delete the two existing data rows and have to add two new attributes. An insertion and deletion anomalies occurred that leads to the data inconsistency. The reason is, student has got relationship with the course in which they have enrolled and with the lecturer who is teaching them. So, if we are deleting something in student table then it automatically got deleted from the course table and then from lecturer table as well. Likewise, while adding a new information into the student table, we have to update into another two tables as well.
Therefore, I preferred to apply the concept of normalization of the data to avoid any data inconsistency. This makes the database less complex and more informative.
Hence, the major part that I have done is I have further split the table using composite key, where I have easily added two new attributes without affecting data in the rows in the primary table. I have tried another way as well where I have just simply added two more columns with new attributes, but I have faced hurdle, as while I was deleting the existing rows, information in those table also got deleted and vice versa, creates a deletion anomaly. Therefore, to prevent this I have created two separate new tables with composite key, where I can easily add, update, insert and delete the data without affecting other tables.
Finally, reaching at fourth version, where, I have to delete the five existing attributes. I have deleted three attributes from student table, each one from the course and lecturer table respectively. Lastly, I have added five new rows with the data.
Overall, it was good experience, I got to know the concept of relationship within the entities and attributes. I have practically applied the normalization concept, found the anomalies within the database and taken the best possible step, by separating the table using composite key. I have also used color highlights to show the changes that I have made in the tables.
Assessment 1_602/TUA_DATABASE TABLE_ASSESSMENT 1.xlsx
Version 1
STUDENT STUDENT ID FNAME LNAME D.O.B COURSE COURSE ID COURSE NAME LOCATION LECTURER LECTURER ID FNAME LNAME
00229977T ALEX SMITH 12/1/95 MGT4068 PROJECT MANAGEMENT THE ROCKS TUA7711 JAMIE TIM
00229978T JOE BERNER 29/04/1989 MGT4069 BUSINESS COMMUNIACTION KENT STREET TUA7712 KEVIN CHIAN
00229979T JAMES ANDERSON 15/09/1991 MGT4070 BUSINESS ENVIRONMENT PYRMONT TUA7713 HEINZ HERMAN
00229980T RINA SHARMA 22/02/1986 MGT4071 SYSTEM ANALYSIS SYDNEY CBD TUA7714 JONNA BILLY
00229981T MOHAN KUMAR 13/05/1994 MGT4072 PROGRAMMING TOWN HALL TUA7715 RAKESH VERMA
00229982T MARIA BELLE 10/08/1889 MGT4073 STATISTICS AND MATHS PITT STREET TUA7716 ROWAN SYED
00229983T SUE XIANG 30/10/1990 MGT4074 STRATEGIC MANAGEMENT KENT STREET TUA7717 MO KADAR
00229984T XIO YANG 19/04/1985 MGT4075 DATA BASE MODELING THE ROCKS TUA7718 LEENA ROY
00229985T PETER ROBERT 20/01/1992 MGT4076 LANGUAGE AND LITERACY WYNARD TUA7719 MARINA JIN
00229986T MAX LEE 16/09/1987 MGT4077 COMPUTER SCIENCE CIRCULAR QUAY TUA7720 SHAH ROMIE
Version 1.2
STUDENT STUDENT ID FNAME LNAME D.O.B COURSE COURSE ID COURSE NAME LOCATION LECTURER LECTURER ID FNAME LNAME
00229977T ALEX SMITH 12/1/95 MGT4068 PROJECT MANAGEMENT THE ROCKS TUA7711 JAMIE TIM
00229978T JOE BERNER 29/04/1989 MGT4069 BUSINESS COMMUNIACTION KENT STREET TUA7712 KEVIN CHIAN
00229979T JAMES ANDERSON 15/09/1991 MGT4070 BUSINESS ENVIRONMENT PYRMONT TUA7713 HEINZ HERMAN
00229980T RINA SHARMA 22/02/1986 MGT4071 SYSTEM ANALYSIS SYDNEY CBD TUA7714 JONNA BILLY
00229981T MOHAN KUMAR 13/05/1994 MGT4072 PROGRAMMING TOWN HALL TUA7715 RAKESH VERMA
00229982T MARIA BELLE 10/08/1889 MGT4073 STATISTICS AND MATHS PITT STREET TUA7716 ROWAN SYED
00229983T SUE XIANG 30/10/1990 MGT4074 STRATEGIC MANAGEMENT KENT STREET TUA7717 MO KADAR
00229984T XIO YANG 19/04/1985 MGT4075 DATA BASE MODELING THE ROCKS TUA7718 LEENA ROY
DELETED ROWS MGT4076 LANGUAGE AND LITERACY WYNARD TUA7719 MARINA JIN
DELETED ROWS MGT4077 COMPUTER SCIENCE CIRCULAR QUAY TUA7720 SHAH ROMIE
00229985T PRIYAH REDDY 6/1/84 ADDED
00229985T XIANG XUEING 7/19/89 ADDED
00229985T KIRTI RAI 2/11/87 ADDED
00229985T RAMAN KAUR 4/21/88 ADDED
00229985T ZOEY SYAED 10/13/90 ADDED
Version 1.3
STUDENT STUDENT ID FNAME LNAME D.O.B COURSE COURSE ID COURSE NAME LOCATION LECTURER LECTURER ID FNAME LNAME
00229977T ALEX SMITH 12/1/95 MGT4068 PROJECT MANAGEMENT THE ROCKS TUA7711 JAMIE TIM
00229978T JOE BERNER 29/04/1989 MGT4069 BUSINESS COMMUNIACTION KENT STREET TUA7712 KEVIN CHIAN
00229979T JAMES ANDERSON 15/09/1991 MGT4070 BUSINESS ENVIRONMENT PYRMONT TUA7713 HEINZ HERMAN
00229980T RINA SHARMA 22/02/1986 MGT4071 SYSTEM ANALYSIS SYDNEY CBD TUA7714 JONNA BILLY
00229981T MOHAN KUMAR 13/05/1994 MGT4072 PROGRAMMING TOWN HALL TUA7715 RAKESH VERMA
00229982T MARIA BELLE 10/08/1889 MGT4073 STATISTICS AND MATHS PITT STREET TUA7716 ROWAN SYED
00229983T SUE XIANG 30/10/1990 MGT4074 STRATEGIC MANAGEMENT KENT STREET TUA7717 MO KADAR
00229984T XIO YANG 19/04/1985 MGT4075 DATA BASE MODELING THE ROCKS TUA7718 LEENA ROY
ROWS HAS BEEN DELETED MGT4076 LANGUAGE AND LITERACY WYNARD TUA7719 MARINA JIN
ROWS HAS BEEN DELETED MGT4077 COMPUTER SCIENCE CIRCULAR QUAY TUA7720 SHAH ROMIE
00229985T PRIYAH REDDY 6/1/84
00229986T XIANG XUEING 7/19/89
00229987T KIRTI RAI 2/11/87
00229988T RAMAN KAUR 4/21/88
00229989T ZOEY SYAED 10/13/90
STUDENT STUDENT ID FNAME ADDRESS NEW ATTRIBUTE ADDED
00229977T ALEX 45, GEORGE ST, SYD CBD STUDENT STUDENT ID FNAME PHONE NUMBER NEW ATTRIBUTE ADDED
00229978T JOE 33, ROWS RD, NEWCASTLE 00229977T ALEX 43463380
00229979T JAMES 51, SILK AVE, ADLEIDE 00229978T JOE 43255112
00229980T RINA 122, QUEENS WLK, AUBURN 00229979T JAMES 45432220
00229981T MOHAN 132, WESTON STREET, HARRIS 00229980T RINA 45511446
00229982T MARIA 89, GREAT WEST HIGHWAY 00229981T MOHAN 42344551
00229983T SUE 119, FIRST ST, KINGSWOOD 00229982T MARIA 456342211
00229984T XIO 221, VALENTINES RD, PARRAMATTA 00229983T SUE 489765547
00229984T XIO 456789911
Version 1.4
STUDENT STUDENT ID FNAME LNAME D.O.B COURSE COURSE ID COURSE NAME LECTURER LECTURER ID FNAME
00229977T ALEX SMITH 12/1/95 MGT4068 PROJECT MANAGEMENT TUA7711 JAMIE
00229978T JOE BERNER 29/04/1989 MGT4069 BUSINESS COMMUNIACTION TUA7712 KEVIN
00229979T JAMES ANDERSON 15/09/1991 MGT4070 BUSINESS ENVIRONMENT TUA7713 HEINZ
00229980T RINA SHARMA 22/02/1986 MGT4071 SYSTEM ANALYSIS TUA7714 JONNA
00229981T MOHAN KUMAR 13/05/1994 MGT4072 PROGRAMMING TUA7715 RAKESH
00229982T MARIA BELLE 10/08/1889 MGT4073 STATISTICS AND MATHS TUA7716 ROWAN
00229983T SUE XIANG 30/10/1990 MGT4074 STRATEGIC MANAGEMENT TUA7717 MO
00229984T XIO YANG 19/04/1985 MGT4075 DATA BASE MODELING TUA7718 LEENA
ROWS HAS BEEN DELETED MGT4076 LANGUAGE AND LITERACY TUA7719 MARINA
ROWS HAS BEEN DELETED MGT4077 COMPUTER SCIENCE TUA7720 SHAH
00229985T PRIYAH REDDY 6/1/84
00229986T XIANG XUEING 7/19/89
00229987T KIRTI RAI 2/11/87
00229988T RAMAN KAUR 4/21/88
00229989T ZOEY SYAED 10/13/90
00229990T RAHUL SATHI 11/25/93 ROWS ADDED
00229991T MANOJ KUMAR 5/10/1889 ROWS ADDED
00229992T KIM CHEA 4/16/91 ROWS ADDED
00229993T MOHAMMAD KHAN 6/22/90 ROWS ADDED
00229994T SANA RAO 11/6/86 ROWS ADDED
STUDENT STUDENT ID
00229977T STUDENT STUDENT ID FNAME
00229978T 00229977T ALEX
00229979T 00229978T JOE
00229980T 00229979T JAMES
00229981T 00229980T RINA
00229982T 00229981T MOHAN
00229983T 00229982T MARIA
00229984T 00229983T SUE
00229984T XIO
MIS602_A1_PRATEEK_MODELLING EXCEL.xlsx
version 1
Student code First name Last name Age Gender Course Faculty assign Fees (in dollar) Staff code Staff name Gender Depatment
S1 Kent Neal 25 Male MS Brett Morrison 60000 ST1 Brett Morrison Male Faculty
S2 Erin Rivera 26 Female MBA Joanne Hudson 65000 ST2 Jared Whelan Male Accounts
S3 Allison Banks 25 Male MS Brett Morrison 60000 ST3 Keon Franklin Male Accounts
S4 Gail Ninez 26 Female MS Brett Morrison 60000 ST4 Nur Drummond Female Accounts
S5 Paul Dawson 26 Male Economics Dana Weber 57000 ST5 Kirstin Medina Female Management
S6 Ginger Mendez 26 Female MBA Joanne Hudson 65000 ST6 Joanne Hudson Female Faculty
S7 Edward Payne 25 Male MBA Joanne Hudson 65000 ST7 Ricardo Leech Male Management
S8 Henry Douglas 25 Male Economics Dana Weber 57000 ST8 Alister Clarke Male Accounts
S9 Wilfred Roy 24 Male MS Brett Morrison 60000 ST9 Verity Bond Male Accounts
S10 Conrad Yates 27 Male MS Brett Morrison 60000 ST10 Rochelle Delaney Male Accounts
S11 Peter Simmons 25 Male Journalism Sylvia Taylor 61000 ST11 Tahmid Hebert Male Management
S12 Mary Gomez 26 Female MS Brett Morrison 60000 ST12 Dana Weber Male Faculty
S13 Alexandra Hale 24 Female MS Brett Morrison 60000 ST13 Sukhmani Bone Female Management
S14 Rita Gomez 25 Female Economics Dana Weber 57000 ST14 Lilly-Rose Dotson Female Management
S15 Sara Washington 25 Female MBA Joanne Hudson 65000 ST15 Bodhi Norton Male Management
S16 Emilio Harper 26 Female MBA Joanne Hudson 65000 ST16 Mahad Houston Male Non teaching staff
S17 Tiffany Holloway 27 Female Economics Dana Weber 61000 ST17 Sylvia Taylor Male Faculty
S18 Miranda Banks 28 Male MS Brett Morrison 60000 ST18 Jordana Harrison Female Non teaching staff
S19 Rosalie Frank 24 Male MS Brett Morrison 60000 ST19 Alyssa Tucker Female Non teaching staff
S20 Wilson Hall 25 Male Journalism Sylvia Taylor 61000 ST20 Cinar Irwin Male Faculty
S21 Gabriel Power 26 Male Economics Dana Weber 61000 ST21 Everly Holloway Female Non teaching staff
S22 Mona Pratt 25 Female MS Brett Morrison 60000 ST22 Cheryl Calvert Female Faculty
S23 Seth Simmons 26 Male MS Brett Morrison 60000 ST23 Adil Taylor Female Faculty
S24 Sharon Sims 25 Female Economics Dana Weber 57000 ST24 Brittany Vaughan Male Faculty
S25 Sonia Fletcher 26 Male MS Brett Morrison 60000 ST25 Leila Sierra Female Non teaching staff
S26 Sally Manning 28 Male Economics Dana Weber 57000 ST26 Merlin O’Doherty Male Non teaching staff
S27 Joel Matthews 27 Male Journalism Sylvia Taylor 61000 ST27 Jarod Chen Male Faculty
S28 Ashley brown 25 Male Economics Dana Weber 57000 ST28 Lorena Mccaffrey Male Non teaching staff
S29 Kim Norris 26 Female MBA Joanne Hudson 65000 ST29 Ayva Aguilar Female Faculty
S30 Alberta Christensen 25 Male MBA Joanne Hudson 65000 ST30 Anne-Marie Blundell Female Faculty
Version 2
Student code First name Last name Age Gender Course Faculty assign Fees (in dollar) Staff code Staff name Gender Depatment
S1 Kent Neal 25 Male MS Brett Morrison 60000 ST1 Brett Morrison Male Faculty
S2 Erin Rivera 26 Female MBA Joanne Hudson 65000 ST2 Jared Whelan Male Accounts
S3 Allison Banks 25 Male MS Brett Morrison 60000 ST3 Keon Franklin Male Accounts
S4 Gail Ninez 26 Female MS Brett Morrison 60000 ST4 Nur Drummond Female Accounts
S5 Paul Dawson 26 Male Economics Dana Weber 57000 ST5 Kirstin Medina Female Management
S6 Ginger Mendez 26 Female MBA Joanne Hudson 65000 ST6 Joanne Hudson Female Faculty
S7 Edward Payne 25 Male MBA Joanne Hudson 65000 ST7 Ricardo Leech Male Management
S8 Henry Douglas 25 Male Economics Dana Weber 57000 ST8 Alister Clarke Male Accounts
S9 Wilfred Roy 24 Male MS Brett Morrison 60000 ST9 Verity Bond Male Accounts
S10 Conrad Yates 27 Male MS Brett Morrison 60000 ST10 Rochelle Delaney Male Accounts
S11 Peter Simmons 25 Male Journalism Sylvia Taylor 61000 ST11 Tahmid Hebert Male Management
S12 Mary Gomez 26 Female MS Brett Morrison 60000 ST12 Dana Weber Male Faculty
S13 Alexandra Hale 24 Female MS Brett Morrison 60000 ST13 Sukhmani Bone Female Management
S14 Rita Gomez 25 Female Economics Dana Weber 57000 ST14 Lilly-Rose Dotson Female Management
S15 Sara Washington 25 Female MBA Joanne Hudson 65000 ST15 Bodhi Norton Male Management
S16 Emilio Harper 26 Female MBA Joanne Hudson 65000 ST16 Mahad Houston Male Non teaching staff
S17 Tiffany Holloway 27 Female Economics Dana Weber 61000 ST17 Sylvia Taylor Male Faculty
S18 Miranda Banks 28 Male MS Brett Morrison 60000 ST18 Jordana Harrison Female Non teaching staff
S19 Rosalie Frank 24 Male MS Brett Morrison 60000 ST19 Alyssa Tucker Female Non teaching staff
S20 Wilson Hall 25 Male Journalism Sylvia Taylor 61000 ST20 Cinar Irwin Male Faculty
S21 Gabriel Power 26 Male Economics Dana Weber 61000 ST21 Everly Holloway Female Non teaching staff
S22 Mona Pratt 25 Female MS Brett Morrison 60000 ST22 Cheryl Calvert Female Faculty
S23 Seth Simmons 26 Male MS Brett Morrison 60000 ST23 Adil Taylor Female Faculty
S24 Sharon Sims 25 Female Economics Dana Weber 57000 ST24 Brittany Vaughan Male Faculty
S25 Sonia Fletcher 26 Male MS Brett Morrison 60000 ST25 Leila Sierra Female Non teaching staff
S26 Sally Manning 28 Male Economics Dana Weber 57000 ST26 Merlin O’Doherty Male Non teaching staff
S27 Joel Matthews 27 Male Journalism Sylvia Taylor 61000 ST27 Jarod Chen Male Faculty
S28 Ashley brown 25 Male Economics Dana Weber 57000 ST28 Lorena Mccaffrey Male Non teaching staff
S29 Kim Norris 26 Female MS Brett Morrison 60000 ST29 Ayva Aguilar Female Accounts
S30 Alberta Christensen 26 Male Economics Dana Weber 57000 ST30 Anne-Marie Blundell Female Accounts
S31 Enrique Paul 26 Male MS Brett Morrison 60000 ST31 Remy Cordova Female Faculty
S32 Justin Jonson 25 Male MS Brett Morrison 60000 ST32 Eryk Reese Female Faculty
S33 Kim Lara 27 Female MBA Joanne Hudson 65000 ST33 Kimberley Hollis Female Non teaching staff
S34 Andrew Mcbeth 25 Male Journalism Sylvia Taylor 61000 ST34 Willie Savage Male Accounts
S35 Tom Noman 26 Male Economics Dana Weber 57000 ST35 Claudia Tierney Female Accounts
Version 3
Student code First name Last name Age Gender Course Faculty assign Fees (in dollar) DOB Campus Staff code Staff name Gender Depatment Campus Reporting department
S1 Kent Neal 25 Male MS Brett Morrison 60000 23/02/1995 North Campus ST1 Brett Morrison Male Faculty North Campus Management
S2 Erin Rivera 26 Female MBA Joanne Hudson 65000 20/04/1994 South Campus ST2 Jared Whelan Male Accounts South Campus Management
S3 Allison Banks 25 Male MS Brett Morrison 60000 21/06/1995 North Campus ST3 Keon Franklin Male Accounts South Campus Management
S4 Gail Ninez 26 Female MS Brett Morrison 60000 23/05/1994 North Campus ST4 Nur Drummond Female Accounts North Campus Management
S5 Paul Dawson 26 Male Economics Dana Weber 57000 12/4/94 North East Campus ST5 Kirstin Medina Female Management East Campus Management
S6 Ginger Mendez 26 Female MBA Joanne Hudson 65000 14/09/1994 South Campus ST6 Joanne Hudson Female Faculty South Campus Management
S7 Edward Payne 25 Male MBA Joanne Hudson 65000 14/03/1995 South Campus ST7 Ricardo Leech Male Management East Campus Management
S8 Henry Douglas 25 Male Economics Dana Weber 57000 10/12/95 North East Campus ST8 Alister Clarke Male Accounts East Campus Management
S9 Wilfred Roy 24 Male MS Brett Morrison 60000 15/04/1996 North Campus ST9 Verity Bond Male Accounts South Campus Management
S10 Conrad Yates 27 Male MS Brett Morrison 60000 12/6/93 North Campus ST10 Rochelle Delaney Male Accounts East Campus Management
S11 Peter Simmons 25 Male Journalism Sylvia Taylor 61000 12/5/95 East Campus ST11 Tahmid Hebert Male Management South Campus Management
S12 Mary Gomez 26 Female MS Brett Morrison 60000 30/12/1994 North Campus ST12 Dana Weber Male Faculty North East Campus Management
S13 Alexandra Hale 24 Female MS Brett Morrison 60000 15/02/1996 North Campus ST13 Sukhmani Bone Female Management South Campus Management
S14 Rita Gomez 25 Female Economics Dana Weber 57000 15/07/1995 North East Campus ST14 Lilly-Rose Dotson Female Management East Campus Management
S15 Sara Washington 25 Female MBA Joanne Hudson 65000 16/05/1995 South Campus ST15 Bodhi Norton Male Management South Campus Management
S16 Emilio Harper 26 Female MBA Joanne Hudson 65000 15/05/1994 South Campus ST16 Mahad Houston Male Non teaching staff North East Campus Accounts
S17 Tiffany Holloway 27 Female Economics Dana Weber 61000 26/05/1993 North East Campus ST17 Sylvia Taylor Male Faculty East Campus Management
S18 Miranda Banks 28 Male MS Brett Morrison 60000 15/04/1992 North Campus ST18 Jordana Harrison Female Non teaching staff North East Campus Accounts
S19 Rosalie Frank 24 Male MS Brett Morrison 60000 5/5/96 North Campus ST19 Alyssa Tucker Female Non teaching staff East Campus Accounts
S20 Wilson Hall 25 Male Journalism Sylvia Taylor 61000 11/7/95 East Campus ST20 Cinar Irwin Male Faculty South Campus Management
S21 Gabriel Power 26 Male Economics Dana Weber 61000 15/04/1994 North East Campus ST21 Everly Holloway Female Non teaching staff East Campus Accounts
S22 Mona Pratt 25 Female MS Brett Morrison 60000 15/5/1995 North Campus ST22 Cheryl Calvert Female Faculty South Campus Accounts
S23 Seth Simmons 26 Male MS Brett Morrison 60000 5/5/94 North Campus ST23 Adil Taylor Female Faculty North East Campus Management
S24 Sharon Sims 25 Female Economics Dana Weber 57000 26/7/1995 North East Campus ST24 Brittany Vaughan Male Faculty South Campus Management
S25 Sonia Fletcher 26 Male MS Brett Morrison 60000 14/4/1994 North Campus ST25 Leila Sierra Female Non teaching staff East Campus Accounts
S26 Sally Manning 28 Male Economics Dana Weber 57000 4/9/92 North East Campus ST26 Merlin O’Doherty Male Non teaching staff South Campus Accounts
S27 Joel Matthews 27 Male Journalism Sylvia Taylor 61000 14/6/1992 East Campus ST27 Jarod Chen Male Faculty North East Campus Management
S28 Ashley brown 25 Male Economics Dana Weber 57000 25/4/1995 North East Campus ST28 Lorena Mccaffrey Male Non teaching staff East Campus Accounts
S29 Kim Norris 26 Female MS Brett Morrison 60000 4/9/94 North Campus ST29 Ayva Aguilar Female Accounts South Campus Management
S30 Alberta Christensen 26 Male Economics Dana Weber 57000 4/4/94 North East Campus ST30 Anne-Marie Blundell Female Accounts East Campus Management
S31 Enrique Paul 26 Male MS Brett Morrison 60000 6/8/94 North Campus ST31 Remy Cordova Female Faculty South Campus Management
S32 Justin Jonson 25 Male MS Brett Morrison 60000 19/5/1995 North Campus ST32 Eryk Reese Female Faculty North East Campus Management
S33 Kim Lara 27 Female MBA Joanne Hudson 65000 14/7/1993 South Campus ST33 Kimberley Hollis Female Non teaching staff South Campus Accounts
S34 Andrew Mcbeth 25 Male Journalism Sylvia Taylor 61000 6/5/95 East Campus ST34 Willie Savage Male Accounts East Campus Management
S35 Tom Noman 26 Male Economics Dana Weber 57000 7/9/94 North East Campus ST35 Claudia Tierney Female Accounts South Campus Management
Version 4
Student code First name Last name Age Gender Staff code
S1 Kent Neal 25 Male ST1
S2 Erin Rivera 26 Female ST2
S3 Allison Banks 25 Male ST3
S4 Gail Ninez 26 Female ST4
S5 Paul Dawson 26 Male ST5
S6 Ginger Mendez 26 Female ST6
S7 Edward Payne 25 Male ST7
S8 Henry Douglas 25 Male ST8
S9 Wilfred Roy 24 Male ST9
S10 Conrad Yates 27 Male ST10
S11 Peter Simmons 25 Male ST11
S12 Mary Gomez 26 Female ST12
S13 Alexandra Hale 24 Female ST13
S14 Rita Gomez 25 Female ST14
S15 Sara Washington 25 Female ST15
S16 Emilio Harper 26 Female ST16
S17 Tiffany Holloway 27 Female ST17
S18 Miranda Banks 28 Male ST18
S19 Rosalie Frank 24 Male ST19
S20 Wilson Hall 25 Male ST20
S21 Gabriel Power 26 Male ST21
S22 Mona Pratt 25 Female ST22
S23 Seth Simmons 26 Male ST23
S24 Sharon Sims 25 Female ST24
S25 Sonia Fletcher 26 Male ST25
S26 Sally Manning 28 Male ST26
S27 Joel Matthews 27 Male ST27
S28 Ashley brown 25 Male ST28
S29 Kim Norris 26 Female ST29
S30 Alberta Christensen 26 Male ST30
S31 Enrique Paul 26 Male ST31
S32 Justin Jonson 25 Male ST32
S33 Kim Lara 27 Female ST33
S34 Andrew Mcbeth 25 Male ST34
S35 Tom Noman 26 Male ST35
S36 Nil Anderson 25 Male ST36
S37 Robert Flintoff 26 Male ST37
S38 Mariana Gomez 27 Female ST38
S39 Emma Parkinson 25 Female ST39
S40 Jonney Jonson 25 Male ST40
MIS_602_A1_PRATEEK_MODELLING REPORT x
Running head: peer assessment of file-based database design
Peer assessment of file-based database design 2
PEER ASSESSMENT OF FILE-BASED DATABASE DESIGN
Table of Contents
ER Diagram…………………………………………………………………………………………………………………….3
Part 2 3
Critique 4-5
Bibliography 6
Part 1
Introduction
Database management system for Torrens University Australia (TUA)will be created in the project. In that situation student table will be created. This database is flexible and management can delete, add or modify and data from database.
ER Diagram
Part 2
Critique
In a database management system, it is essential to create an entity relationship diagram. In the concerned database, ER diagram has been created by including attributes, entity as well as a relation among them. Two tables, such as student and staff, has been created in this purpose that has more than one attributes. In the staff table, there are staff name, gender, department as well as reporting department. On the other hand, there is a student table has student code, first name, last name as well as course and faculty. In version 1 database has been prepared by adding 30 rows in each table (Dyer & Rogers, 2015). On the other hand, version 2 of the database is responsible for updating two rows and add five more rows. In version 3, two attributes have been added in the staff and student table.
It is recommended to improve attribute and objectives of the data continually. In this situation, data normalization process can be used for making the table more flexible. Several steps are there in the database. First normalized form of data is responsible for containing single value in each cell. Apart from that, data must be unique, and there should not be any duplication of data as it consumes more memory (Mills, Beaulieu & Johnson, 2017). For example, in the student table student name has not used twice and complete details of a particular student can be found out from a single row. After completing 1NF, database designer must implement 2NF in the table. According to 2NF strategy, table must have a primary key, and it must be single columned value. A primary key is required for identifying a particular row from the database. As the primary key is unique, and it is useful for finding value. For example, in the student table, student code is primary key as it is unique.
Apart from primary key, composite key and foreign key has lots of benefits in the organization. Two or more columns are used for creating a composite key. Apart from primary key and composite key, a foreign key is required for joining between two or more table (Taipalus, 2019). In that situation, it is necessary to have same attribute in both tables for joining purpose. For example, in the student table and in staff table, staff name is common that can be used for joining these two tables (Tirmann&Tabusca, 2016). ER diagram has been prepared for understanding about database structure. Entity and relationship among them can be identified through ER diagram. As building database is a complex process, it is needed to understand several components of the database before implementing it (Zhuchenko, Osipa&Cheropkin, 2017). An ER diagram is responsible for providing and analysing those components for a better database management system. Logical structure of a database system can be explained with the help of ER diagram. Different type shapes has been used in the system for making this ER diagram. For example, over shape is required for identifyingattributes of the system.
Bibliography
Dyer, J. N., & Rogers, C. (2015). Adapting the access northwind database to support a database course. Journal of Information Systems Education, 26(2), 85-101. Retrieved from https://search.proquest.com/docview/1783992953?accountid=30552
Mills, R. J., Beaulieu, T. Y., & Johnson, J. J. (2017). Examining micro-level (SQL) curriculum-oriented and promotional IS enrollment strategies. The Journal of Computer Information Systems, 57(4), 299-308. doi:http://dx.doi.org/10.1080/08874417.2016.1180650
Taipalus, T. (2019). A notation for planning SQL queries. Journal of Information Systems Education, 30(3), 160-166. Retrieved from https://search.proquest.com/docview/2291483386?accountid=30552
Tirmann, V., &Tabusca, A. (2016). University student attendance management system. Journal of Information Systems & Operations Management, , 1-11. Retrieved from https://search.proquest.com/docview/1800179885?accountid=30552
Zhuchenko, A. I., Osipa, L. V., &Cheropkin, E. S. (2017). Design database for an automated control system of typical wastewater treatment processes. International Journal of Engineering and Manufacturing, 7(4), 36. doi:http://dx.doi.org/10.5815/ijem.2017.04.04