Data Analysis and Design for Dominican College Course Management System

Data Analysis and
Design
Student Name:
Student ID:

Contents
Introduction............................................................................................................................. 6
LO1 Understand data models and database technologies.......................................................7
1.1 Critically compare different data models and schemas..................................................7
1.2 Critically discuss the benefits and limitations of different database technologies.......12
1.3 Analyse different approaches to database design........................................................14
LO2 Be able to design and implement relational database systems......................................15
2.1 design a relational database system to meet a given requirement..............................15
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..........23
LO3 Be able to use manipulation and querying tools.............................................................27
3.1 Explain the benefits of using manipulation and query tools in a relational database
system................................................................................................................................ 27
3.2 Implement a query language into the relational database system that has been
implemented...................................................................................................................... 29
3.3. Critically evaluates how meaningful data has been extracted through the use of query
tools for the given case study.............................................................................................38
LO4 Be able to test and document relational database systems............................................42
4.1 critically reviews and tests the implemented relational database system....................42
4.2 Create documentation to support the implementation and testing of a relational
database system.................................................................................................................43
4.3 Create user documentation for a developed relational database system....................47
4.4 Explain how verification and validation has been addressed.......................................54
4.5 Explain how control mechanisms have been used.......................................................55
Conclusion.............................................................................................................................. 58
References..............................................................................................................................59
1

List of Figures
Figure 1 Network Data Model..................................................................................................7
Figure 2 Hierarchal Data Model...............................................................................................8
Figure 3 Relational Data Model................................................................................................9
Figure 4 Physical Schema....................................................................................................... 10
Figure 5 Logical Schema......................................................................................................... 11
Figure 6 Conceptual Schema..................................................................................................11
Figure 7 Relationship diagram................................................................................................16
Figure 8 Conceptual Diagram.................................................................................................16
Figure 9 Logical Diagram........................................................................................................ 17
Figure 10 Academic Manager Table.......................................................................................19
Figure 11 Academic Manager Datasheet view.......................................................................19
Figure 12 Admin Table............................................................................................................20
Figure 13 Admin Datasheet view............................................................................................20
Figure 14 Campus Table......................................................................................................... 20
Figure 15 Campus Datasheet view.........................................................................................20
Figure 16 Course Table...........................................................................................................20
Figure 17 Course Datasheet view...........................................................................................21
Figure 18 Lecturer Table.........................................................................................................21
Figure 19 Lecturer Datasheet View........................................................................................21
Figure 20 Student Table......................................................................................................... 21
Figure 21 Student Datasheet View.........................................................................................22
Figure 22 Units Table..............................................................................................................22
Figure 23 Units Datasheet view..............................................................................................22
Figure 24Units Datasheet view...............................................................................................23
Figure 25 Student Table......................................................................................................... 23
Figure 26 Relationship............................................................................................................24
Figure 27 Academic manager form........................................................................................24
Figure 28Admin form............................................................................................................. 25
2

Figure 29 Academic manager report......................................................................................25
Figure 30 Admin report..........................................................................................................26
Figure 31 Query1 design view................................................................................................29
Figure 32 Query1 output........................................................................................................29
Figure 33 Query1 Report view................................................................................................30
Figure 34 Query2 design view................................................................................................31
Figure 35 Query2 Output....................................................................................................... 31
Figure 36 Query2 Report view................................................................................................31
Figure 37 Query3 Design view................................................................................................32
Figure 38 Query3 Output....................................................................................................... 32
Figure 39 Query3 Report view................................................................................................32
Figure 40 Query4 design view................................................................................................34
Figure 41 Query4 output........................................................................................................34
Figure 42 Query4 Report view................................................................................................34
Figure 43 Query5 design view................................................................................................35
Figure 44 Query5 Output....................................................................................................... 35
Figure 45 Query5 Report view................................................................................................36
Figure 46 Query6 Design view................................................................................................37
Figure 47 Query6 output........................................................................................................37
Figure 48 Query6 report view................................................................................................ 37
Figure 49 Academic Manager Query......................................................................................38
Figure 50 Output of Academic Manager Query......................................................................38
Figure 51 admin query........................................................................................................... 38
Figure 52 Output of Admin query...........................................................................................39
Figure 53 Courses Query........................................................................................................ 39
Figure 54 Output of Course Query.........................................................................................39
Figure 55 Lecturer Query........................................................................................................40
Figure 56 Output of Lecture Query........................................................................................40
Figure 57 Student Query........................................................................................................ 41
Figure 58 Output of Student Query........................................................................................41
Figure 59 Test 1...................................................................................................................... 44
Figure 60 test-2...................................................................................................................... 44
3

Figure 61 test-3...................................................................................................................... 44
Figure 62 test 4.......................................................................................................................45
Figure 63 test 5.......................................................................................................................45
Figure 64 test 6.......................................................................................................................46
Figure 65 Academic manager form........................................................................................47
Figure 66 Academic-manager report......................................................................................48
Figure 67 Admin Form............................................................................................................48
Figure 68 Academic report.....................................................................................................49
Figure 69 Course Form........................................................................................................... 49
Figure 70 Course Report.........................................................................................................50
Figure 71 Campus Report.......................................................................................................50
Figure 72 Campus Report.......................................................................................................51
Figure 73 Lecturer Form.........................................................................................................51
Figure 74 Lecturer Report...................................................................................................... 52
Figure 75 Student Form..........................................................................................................52
Figure 76 Student Report....................................................................................................... 52
Figure 77 Units Form..............................................................................................................53
Figure 78 Units Report........................................................................................................... 53
Figure 79 Validation in Lecturer Table....................................................................................54
Figure 80 Academic manager control mechanism.................................................................55
Figure 81 academic manager control mechanism..................................................................56
Figure 82 lecture table control mechanism............................................................................57
4

List of Tables
Table 1 Benefits and Limitation of Different Technologies.....................................................12
Table 2 First normal form.......................................................................................................17
Table 3 Second normal form..................................................................................................18
Table 4 Third normal form..................................................................................................... 18
Table 5 feedback.................................................................................................................... 42
Table 6 Test cases...................................................................................................................43
5

Introduction
System Analysis and Design is an entire procedure of given framework breaking down. This
report presents key issues of a relational database, data models with their advantages and
disadvantages and giving a best attainable answer for a given issue. It supports the
proposed framework with everyday future advancements. This report presents
development and designing of the database for Dominican College that is located in
northwest of new your city. In designing of database, Conceptual and logical ER is designed.
In development, tables, forms, query, and report are developed.
In this project, there are four sections in this whole project, in the first section, I will discuss
data models such as relational, hierarchal and network data models, data schema, their
approaches, data designs. In the second section, I will discuss the relational requirements,
user documentation, verification, and normalization. In the third section, I will discuss data
manipulation, query languages and, data maintenance. In the last or the fourth section, I will
make the test plans, feedback form, test cases, and user documentation.
6

LO1 Understand data models and database technologies
1.1 Critically compare different data models and schemas
A database exhibits the clever design of information, including the associations and flaws
that choose how data can be made more secure. Database models are built according to the
database principles and design requirements. Most data models can be addressed by
database graph.
Types of Data Models
Network Data Models
A database demonstrates the consistent structure of a data, including the requirements that
decide how data can be put away. Single database models are designed for considering the
views and ideas that have more extensive information. It can be addressed by running
database.
Figure 1 Network Data Model
Pros: -
 It mainly gives many to many relationships.
 It is easy to access and flexible compared to hierarchal model.
7