Data Analysis and Design: Dominican College Database System
Added on 2024-05-31
59 Pages5567 Words271 Views
|
|
|
Data Analysis and Design
Table of Contents
Introduction......................................................................................................................................4
LO1 Understand data models and database technologies................................................................5
1.1 Critically compare different data models and schemas.........................................................5
1.2 Critically discuss the benefits and limitations of different database technologies................9
1.3 Analyse different approaches to database design................................................................11
LO2 Be able to design and implement relational database systems..............................................15
2.1 Design a relational database system to meet a given requirement......................................15
2NF (second normal form):.......................................................................................................17
2.2 Build a relational database system based on a prepared design..........................................19
2.3 Apply a range of database tools and techniques to enhance the user interface...................21
LO3 Be able to use manipulation and querying tools....................................................................22
3.1 Explain the benefits of using manipulation and query tools in a relational database system
...................................................................................................................................................22
3.2 Implement a query language into the relational database system........................................23
3.3 Critically evaluate how meaningful data has been extracted through the use of query tools
...................................................................................................................................................39
LO4 Be able to test and document relational database systems....................................................43
4.1 Critically review and test a relational database system.......................................................43
4.2 Create documentation to support the implementation and testing of a relational database
system........................................................................................................................................44
4.3 Create user documentation for a developed relational database system..............................47
4.4 Explain how verification and validation has been addressed..............................................52
4.5 Explain how control mechanisms have been used..............................................................53
Conclusion.................................................................................................................................55
References:................................................................................................................................56
Appendix........................................................................................................................................57
1
Introduction......................................................................................................................................4
LO1 Understand data models and database technologies................................................................5
1.1 Critically compare different data models and schemas.........................................................5
1.2 Critically discuss the benefits and limitations of different database technologies................9
1.3 Analyse different approaches to database design................................................................11
LO2 Be able to design and implement relational database systems..............................................15
2.1 Design a relational database system to meet a given requirement......................................15
2NF (second normal form):.......................................................................................................17
2.2 Build a relational database system based on a prepared design..........................................19
2.3 Apply a range of database tools and techniques to enhance the user interface...................21
LO3 Be able to use manipulation and querying tools....................................................................22
3.1 Explain the benefits of using manipulation and query tools in a relational database system
...................................................................................................................................................22
3.2 Implement a query language into the relational database system........................................23
3.3 Critically evaluate how meaningful data has been extracted through the use of query tools
...................................................................................................................................................39
LO4 Be able to test and document relational database systems....................................................43
4.1 Critically review and test a relational database system.......................................................43
4.2 Create documentation to support the implementation and testing of a relational database
system........................................................................................................................................44
4.3 Create user documentation for a developed relational database system..............................47
4.4 Explain how verification and validation has been addressed..............................................52
4.5 Explain how control mechanisms have been used..............................................................53
Conclusion.................................................................................................................................55
References:................................................................................................................................56
Appendix........................................................................................................................................57
1
List of Figures
Figure 1 Network data model..........................................................................................................5
Figure 2 Hierarchical database model.............................................................................................6
Figure 3 Object-oriented database model........................................................................................6
Figure 4 Relational database model.................................................................................................7
Figure 5 Database schema with 3 layers..........................................................................................8
Figure 6 Relationship diagram.......................................................................................................15
Figure 7 ER diagram......................................................................................................................16
Figure 8 Design view of academic manager table.........................................................................19
Figure 9 Design view of admin table.............................................................................................19
Figure 10 Design view of course table..........................................................................................19
Figure 11 Design view of lecturer table........................................................................................19
Figure 12 Design view of student table.........................................................................................20
Figure 13 Design view of units table.............................................................................................20
Figure 14 Query 1 design view......................................................................................................23
Figure 15 Query 1 output view......................................................................................................23
Figure 16 Query 1 report view.......................................................................................................24
Figure 17 Query 2 design view......................................................................................................25
Figure 18 Query 2 output view......................................................................................................25
Figure 19 Query 2 report view.......................................................................................................26
Figure 20 Query 3 design view......................................................................................................27
Figure 21 Query 3 output view......................................................................................................27
Figure 22 Query 3 report view.......................................................................................................28
Figure 23 Query 4 design view......................................................................................................29
Figure 24 Query 4 output view......................................................................................................29
Figure 25 Query 4 report view.......................................................................................................30
Figure 26 Query 5 design view......................................................................................................31
Figure 27 Query 5 output view......................................................................................................31
Figure 28 Query 5 report view.......................................................................................................32
Figure 29 Query 6 design view......................................................................................................33
Figure 30 Query 6 output view......................................................................................................33
Figure 31 Query 6 report view.......................................................................................................34
Figure 32 Query 7 design view......................................................................................................35
Figure 33 Query 7 output view......................................................................................................35
Figure 34 Query 7 report view.......................................................................................................36
Figure 35 Query 8 design view......................................................................................................37
Figure 36 Query 8 output view......................................................................................................37
Figure 37 Query 8 report view.......................................................................................................38
Figure 38 SQL view of admin query.............................................................................................39
Figure 39 Output view of admin query..........................................................................................39
2
Figure 1 Network data model..........................................................................................................5
Figure 2 Hierarchical database model.............................................................................................6
Figure 3 Object-oriented database model........................................................................................6
Figure 4 Relational database model.................................................................................................7
Figure 5 Database schema with 3 layers..........................................................................................8
Figure 6 Relationship diagram.......................................................................................................15
Figure 7 ER diagram......................................................................................................................16
Figure 8 Design view of academic manager table.........................................................................19
Figure 9 Design view of admin table.............................................................................................19
Figure 10 Design view of course table..........................................................................................19
Figure 11 Design view of lecturer table........................................................................................19
Figure 12 Design view of student table.........................................................................................20
Figure 13 Design view of units table.............................................................................................20
Figure 14 Query 1 design view......................................................................................................23
Figure 15 Query 1 output view......................................................................................................23
Figure 16 Query 1 report view.......................................................................................................24
Figure 17 Query 2 design view......................................................................................................25
Figure 18 Query 2 output view......................................................................................................25
Figure 19 Query 2 report view.......................................................................................................26
Figure 20 Query 3 design view......................................................................................................27
Figure 21 Query 3 output view......................................................................................................27
Figure 22 Query 3 report view.......................................................................................................28
Figure 23 Query 4 design view......................................................................................................29
Figure 24 Query 4 output view......................................................................................................29
Figure 25 Query 4 report view.......................................................................................................30
Figure 26 Query 5 design view......................................................................................................31
Figure 27 Query 5 output view......................................................................................................31
Figure 28 Query 5 report view.......................................................................................................32
Figure 29 Query 6 design view......................................................................................................33
Figure 30 Query 6 output view......................................................................................................33
Figure 31 Query 6 report view.......................................................................................................34
Figure 32 Query 7 design view......................................................................................................35
Figure 33 Query 7 output view......................................................................................................35
Figure 34 Query 7 report view.......................................................................................................36
Figure 35 Query 8 design view......................................................................................................37
Figure 36 Query 8 output view......................................................................................................37
Figure 37 Query 8 report view.......................................................................................................38
Figure 38 SQL view of admin query.............................................................................................39
Figure 39 Output view of admin query..........................................................................................39
2
Figure 40 SQL view of academic manager query.........................................................................39
Figure 41 Output view of academic manager query......................................................................40
Figure 42 SQL view of college admin query.................................................................................40
Figure 43 Output view of college admin query.............................................................................41
Figure 44 SQL view of student query............................................................................................41
Figure 45 Output view of student query........................................................................................42
Figure 46 Test case 1.....................................................................................................................44
Figure 47 Test case 2.....................................................................................................................45
Figure 48 Test case 3.....................................................................................................................45
Figure 49 Test case 4.....................................................................................................................45
Figure 50 Test case 5.....................................................................................................................46
Figure 51 Academic manager form...............................................................................................47
Figure 52 Admin form...................................................................................................................47
Figure 53 Course form...................................................................................................................47
Figure 54 Lecturer form.................................................................................................................48
Figure 55 Student form..................................................................................................................48
Figure 56 Unit form.......................................................................................................................49
Figure 57 Academic manager form report.....................................................................................49
Figure 58 Admin form report........................................................................................................50
Figure 59 Course form report........................................................................................................50
Figure 60 Student form report.......................................................................................................51
Figure 61 Validation On lecturer phone no...................................................................................52
Figure 62 Control mechanism for admin table..............................................................................53
Figure 63 Control mechanism for admin table in course id..........................................................54
List of Tables
Table 1 Un normalized table..........................................................................................................12
Table 2 First NF form....................................................................................................................12
Table 3 Second (1) NF...................................................................................................................12
Table 4 Second(2) NF....................................................................................................................12
Table 5 Third (1) NF......................................................................................................................13
Table 6 Third (2) NF......................................................................................................................13
Table 7 Third (3) NF......................................................................................................................13
Table 8 First normal form table of database..................................................................................17
Table 9 Second normal form of database......................................................................................17
Table 10 Third normal form of database.......................................................................................18
Table 11 Feedback table by different users...................................................................................43
Table 12 Test cases table...............................................................................................................44
3
Figure 41 Output view of academic manager query......................................................................40
Figure 42 SQL view of college admin query.................................................................................40
Figure 43 Output view of college admin query.............................................................................41
Figure 44 SQL view of student query............................................................................................41
Figure 45 Output view of student query........................................................................................42
Figure 46 Test case 1.....................................................................................................................44
Figure 47 Test case 2.....................................................................................................................45
Figure 48 Test case 3.....................................................................................................................45
Figure 49 Test case 4.....................................................................................................................45
Figure 50 Test case 5.....................................................................................................................46
Figure 51 Academic manager form...............................................................................................47
Figure 52 Admin form...................................................................................................................47
Figure 53 Course form...................................................................................................................47
Figure 54 Lecturer form.................................................................................................................48
Figure 55 Student form..................................................................................................................48
Figure 56 Unit form.......................................................................................................................49
Figure 57 Academic manager form report.....................................................................................49
Figure 58 Admin form report........................................................................................................50
Figure 59 Course form report........................................................................................................50
Figure 60 Student form report.......................................................................................................51
Figure 61 Validation On lecturer phone no...................................................................................52
Figure 62 Control mechanism for admin table..............................................................................53
Figure 63 Control mechanism for admin table in course id..........................................................54
List of Tables
Table 1 Un normalized table..........................................................................................................12
Table 2 First NF form....................................................................................................................12
Table 3 Second (1) NF...................................................................................................................12
Table 4 Second(2) NF....................................................................................................................12
Table 5 Third (1) NF......................................................................................................................13
Table 6 Third (2) NF......................................................................................................................13
Table 7 Third (3) NF......................................................................................................................13
Table 8 First normal form table of database..................................................................................17
Table 9 Second normal form of database......................................................................................17
Table 10 Third normal form of database.......................................................................................18
Table 11 Feedback table by different users...................................................................................43
Table 12 Test cases table...............................................................................................................44
3
Introduction
Database design is the design process of the database and recognize the general basics of the
database system. For designing the database MS Access framework is used. The detailed
description of this report will generate for Dominican college database system. In this
assignment, the assignment is divided into four tasks. Different database technologies and
diverse methods for the creation of a database model are deliberated. In this, it will also contain
the information of normalization, verifications, and requirements of database and the
documentation for user which helps the operator to access and practise the database. It also
contains the detail of query language. In last part of the report the diverse test cases, test plans
and the user feedback are described.
4
Database design is the design process of the database and recognize the general basics of the
database system. For designing the database MS Access framework is used. The detailed
description of this report will generate for Dominican college database system. In this
assignment, the assignment is divided into four tasks. Different database technologies and
diverse methods for the creation of a database model are deliberated. In this, it will also contain
the information of normalization, verifications, and requirements of database and the
documentation for user which helps the operator to access and practise the database. It also
contains the detail of query language. In last part of the report the diverse test cases, test plans
and the user feedback are described.
4
LO1 Understand data models and database technologies
1.1 Critically compare different data models and schemas
Database management system: It is the software for a computer that can communicate with an
application, database, End-user for the analysis and for collecting data. Database management
system will allow database administrator to update, define, creation of database. Database will
contain information which can be managed by a database administrator. Different types of
database are network database, object-oriented, relational, hierarchical database.
Network database: This model contains a logical type of database. In this model, the connection
is contained among the nodes, their direction and the node cost. This type of database is
completed extremely because many-to-many relationship contains in between the nodes for the
one record that can be used by entire database.
Figure 1 Network data model
Source: (tutorial4begineer, 2018)
Advantages:
It can be handled by several kinds of relationship.
Data integrity and access flexibility are there in this.
Disadvantages:
In this the complex system is present
Complex to maintain the links.
Hierarchical database model: This model forms a tree-like structure which can be contained by
one to numerous type relationships. One parent is behaving as a root which is the top node. It is a
physical type of database which can be used for storing the information.
5
1.1 Critically compare different data models and schemas
Database management system: It is the software for a computer that can communicate with an
application, database, End-user for the analysis and for collecting data. Database management
system will allow database administrator to update, define, creation of database. Database will
contain information which can be managed by a database administrator. Different types of
database are network database, object-oriented, relational, hierarchical database.
Network database: This model contains a logical type of database. In this model, the connection
is contained among the nodes, their direction and the node cost. This type of database is
completed extremely because many-to-many relationship contains in between the nodes for the
one record that can be used by entire database.
Figure 1 Network data model
Source: (tutorial4begineer, 2018)
Advantages:
It can be handled by several kinds of relationship.
Data integrity and access flexibility are there in this.
Disadvantages:
In this the complex system is present
Complex to maintain the links.
Hierarchical database model: This model forms a tree-like structure which can be contained by
one to numerous type relationships. One parent is behaving as a root which is the top node. It is a
physical type of database which can be used for storing the information.
5
Advantages:
Used for sharing the data.
It offers a secure database.
Disadvantages:
Some limitation is faced by the time of implementation of database.
In-depth the hierarchical knowledge is required.
Figure 2 Hierarchical database model
Source: (tutorial4begineer, 2018)
Object-oriented database model: This kind of database can store the data in the form of
objects. The object-oriented languages like C++, JAVA, and others.
Figure 3 Object-oriented database model
Source: (tutorial4begineers, 2018)
6
Used for sharing the data.
It offers a secure database.
Disadvantages:
Some limitation is faced by the time of implementation of database.
In-depth the hierarchical knowledge is required.
Figure 2 Hierarchical database model
Source: (tutorial4begineer, 2018)
Object-oriented database model: This kind of database can store the data in the form of
objects. The object-oriented languages like C++, JAVA, and others.
Figure 3 Object-oriented database model
Source: (tutorial4begineers, 2018)
6
Advantages:
According to the need of user, the data type can be defined.
It can save the method of data automated.
Disadvantages:
Without the knowledge of OOPS, the user cannot use.
It uses the poor reporting and querying tool.
Relational database: It can be widely used for data storage and processing. It stores the data in
table format where row defines the record and in a column, the attributes are defined.
Advantages:
For database design, it can use a simple concept.
For integration of data it can provide a communication in a effective manner.
Disadvantages:
Figure 4 Relational database model
Source: (Parker, 2009)
Database schema: It uses the three-layer structural design where individual level is vital on
behalf of the company. In table format, the data are stored and show the relations with the
different table present in database.
7
According to the need of user, the data type can be defined.
It can save the method of data automated.
Disadvantages:
Without the knowledge of OOPS, the user cannot use.
It uses the poor reporting and querying tool.
Relational database: It can be widely used for data storage and processing. It stores the data in
table format where row defines the record and in a column, the attributes are defined.
Advantages:
For database design, it can use a simple concept.
For integration of data it can provide a communication in a effective manner.
Disadvantages:
Figure 4 Relational database model
Source: (Parker, 2009)
Database schema: It uses the three-layer structural design where individual level is vital on
behalf of the company. In table format, the data are stored and show the relations with the
different table present in database.
7
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Data Analysis and Design for Dominican College Course Management Systemlg...
|62
|6553
|328
Dominican College Course Management Database: Design, Implementation, and Documentationlg...
|59
|6147
|338
Database Design and Implementation for Dominican Collegelg...
|60
|5189
|463
Relational Database Design and Implementation for Dominican Collegelg...
|62
|6951
|171
Database Analysis and Design: A Case Study of Dominican Collegelg...
|102
|8346
|148
Database Assignment: Designing and Implementing a Relational Database System for VET Solutionslg...
|41
|4497
|118