file-based database design

rupali
assessment.zip
Home>Information Systems homework help>file-based database design

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.docx

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

C:\Users\lenovo\Downloads\a9a2e971-3fcb-4303-8b75-57d167be2ba7.JPG

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