Dominican College Data Analysis and Design Project - SQL Database

This project report details a comprehensive data analysis and design assignment, covering various aspects of database management. It begins by comparing different data models and database schemas, discussing their respective benefits and limitations, with a focus on relational, hierarchical, and network models. The project then delves into the practical design of a relational database system, using SQL to meet specific requirements for a case study involving a course management system. It includes building the database, enhancing the user interface, and implementing query languages. The report further explores the benefits of using manipulation and query tools, evaluating data extraction effectiveness. The final sections focus on testing, reviewing, and documenting the implemented database system, including user documentation, data validity verification, and control mechanisms. The report provides a complete analysis of the project from design to implementation and testing.

Data Analysis and Design

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
A.C.1.1 Compare different data models and Scheme............................................................1
A.C.1.2 Discuss the benefits and limitations of different database technologies...................7
A.C. 1.3 Analyse different approaches to database design.....................................................8
TASK 2..........................................................................................................................................12
A.C.2.1 Design a relational database system to meet a given requirements provided in the
given case study....................................................................................................................12
A.C.2.2- Build a relational database system for the database design Domicile College System
using SQL database software...............................................................................................18
A.C.2.3 Apply database tools and techniques to enhance the user interface......................19
TASK 3..........................................................................................................................................22
A.C. 3.1 Benefits of using manipulation and query tools in a relational database system..22
A.C. 3.2 Implement a query language into the relational database system that has been
implement.............................................................................................................................24
A.C. 3.3 Evaluate how meaningful data has been extracted with the use of query tools......26
TASK 4..........................................................................................................................................26
A.C. 4.1 Testing and reviewing the implemented relational database system.....................26
A.C. 4.2 Supporting documentation for database testing and implementation....................27
A.C. 4.3 User documentation for course management database of Dominican college......28
A.C. 4.4 Data validity and verification.................................................................................29
A.C. 4.5 Control mechanisms in database system................................................................30
CONCLUSION..............................................................................................................................30
REFERENCES..............................................................................................................................31
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................3
A.C.1.1 Compare different data models and Scheme............................................................3
A.C.1.2 Discuss the benefits and limitations of different database technologies...................7
A.C.1.3 Analyze different approaches to database design....................................................9
TASK 2..........................................................................................................................................12

A.C.2.1 Design a relational database system to meet a given requirements provided in the
given case study....................................................................................................................12
A.C.2.2- Build a relational database system for the database design Domicile College System
using SQL database software ..............................................................................................18
A.C.2.3 Apply database tools and techniques to enhance the user interface......................19
TASK 3..........................................................................................................................................22
A.C. 3.1 Benefits of using manipulation and query tools in a relational database system .22
A.C. 3.2 Implement a query language into the relational database system that has been
implement.............................................................................................................................24
A.C. 3.3 Evaluate how meaningful data has been extracted with the use of query tools...26
TASK 4..........................................................................................................................................26
A.C. 4.1 Testing and reviewing the implemented relational database system ....................26
A.C. 4.2 Supporting documentation for database testing and implementation....................27
A.C. 4.3 User documentation for course management database of Dominican college .....28
A.C. 4.4 Data validity and verification.................................................................................29
A.C. 4.5 Control mechanisms in database system ...............................................................30
CONCLUSION..............................................................................................................................30
REFERENCES .............................................................................................................................31

INTRODUCTION
Data analysis is a process of modelling data, inspecting, transforming and cleansing with
objective to determine the important information which helpful for decision marking. Data
mining is part of data analysis, it mainly focuses on discovering, and modelling data etc. it also
covers data analysis for business intelligence. Marks and Spencer is a leading organization use
different database technologies for managing their data such as customer details, product
information and company information.
This report will discuss about different data model and what are the benefits of different
database technologies. It also analyses various strategies and approaches for database design.
This assignment will discuss about relational database to identify the requirement of techniques
and tools for designing to meet the need of case study. Further, this report will discuss about the
query language tools which is helpful in relational database. Afterwards, it also implements the
test in rational database system to create documentations for maintaining the database in proper
manner (Lewis, 2015). This report describes validation and verification techniques in relational
database system.
TASK 1
A.C.1.1 Compare different data models and Scheme
Data model Database schema
Stage Data model is basically used
for conceptual system
modeling.
Database schema is a process
which is useful for system
implementation.
Purpose Data model is design database
management system.
Data schema is applicable in
database system to
implementation.
Level of details Data model is using low and
medium key attributes.
Data schema is applicable in
high data and it also defines
the specific relations between
objects.
Tool Data model uses CASE and It uses database development
1

diagram tools which helps for
design purpose.
and management tools.
Form Data model is using graphical
UML diagram to represent the
entities and attributes.
Database form in structure
form like tables, columns and
rows.
Comparison between data models:
Hierarchical Model Network data model Relational data
model
Data structure  Hierarchical
data model
follow one to
one and many
to many
relationships.
 This model is
based on child
relationship.
 Network data
model follow
many to many
relationships.
 This model is
record many
parents and
many children.
 Relational data
model follows
one to one and
many to many
relationships.
 This model is
based on data
structure.
Data manipulation  This model has
no independent
stand-alone
query.
 Retrieve
algorithm is
very complex.
 Retrieve
algorithm is
very complex.
 Retrieve
algorithm is
very complex.
Data integrity  Hierarchical
model doesn't
insert any data
related the
child and
 This model is
not suffers for
inserting
 It allows
inserting the
values on table.
 It can be free to
update
2

doesn't have
parents
values.
 It is freely
updated data
and
informationsinf
ormation’s,
delete and free
to edits.
anomalies due
to
normalisation
process.
Data model is an abstract model that is helpful for designing a logical database. It shows that
how the entities and data are connected with each other. They are processed for storing data in
the form of database management system. Data model can be divided into three ways: -
 Network Data Model
 Hierarchical Data model
 Relational data model
There are important data model which is helpful for storing the information and data in
proper manner. Marks and Spencer is a leading organization and they are also using database
management system to secure their customer information and company details in proper way.
Hierarchical Data model- Hierarchical database model is organized in the form of tree
structure. This data model has one parents and many children (Kratochwill, 2015). Nodes are
connected to each other in the form of tree.connected to each other in the form of tree.
3

Illustration 1: Hierarchical data model
(Source: Hierarchical data model, 2013)
Network Data Model- A network database model allows the multiple record to link with the
same file. This data model is designed as flexible way to represent objects and their specific
relationship. In this model, all the entities are managed in the form of graph. This is complex
structure and nor flexible to identify the model. Network model has many parents and many
children.
4
Illustration 2: Network data model structure
(Source: (Network model, 2013)

Relational Data model- The relational data model is type of database management to
arrange data in the form of table and structure. This model is providing the declarative method
for identifying the specific queries and data. Relational data model is most popular database
management system that has relationship with another database (Baek, Meroni and Manzini,
2015). Marks and Spencer is using this model to manage the complex data in proper ways.
Relational model is developed for reducing the complexity in the database management system.
The database management has many to many relationships with the entities.
Database Schema- The database schema is database management system that is
described in formal language. Database schema is structure that shows the logical view of whole
database therefore, how data can organize and create relationship between two tables. Database
defines the relationship between entities.
5
Illustration 3: Relational database model
(Source: (Relational data model, 2013)

Physical schema- This schema is main part of database management system because it
stores the actual data in different forms such as files and indices etc. It can be represented that
how the data stored in the secondary database (Taylor, 2017).
Logical schema- This schema is defining all the logical constraints which is applied in
the data storage. According to this schema, the data store in form of views, tables, and integrity
constraints.
Data dictionary language- Data dictionary language store information in the form of
structure such as type of data and size. It also defines relationship between databases. The
6
Illustration 4: Database Schema
(Source (:: Data base system, 2017)

company's authorized person can easily change the database environment with the help of DDL
(data description language).
Data manipulation language- Data manipulation language is useful for performing
different operations such as creations, insertion, organising, retrieve and deletion in database.
Mark and Spencer is using this language to delete some data in the database management system.
Data independence- it is major advantages of relational database because it can be split
the data in the form of table like horizontal and vertical form.
A.C.1.2 Discuss the benefits and limitations of different database technologies
Database technologies are important part for Marks and Spencer that is managed the data
effectively and efficiently. This organization is using different tools and platform for arranging
the information. Firstly, Database management system is an effective process that is
manufactured by Microsoft. This database concept is useful for both business organizations and
individuals (Xia and Wishart, 2016). For managing huge amount of database which is useful for
Microsoft SQL server. It is unique platform for creating report, charts, tables and matrices etc.
For creating database, which is not required for complex programs in database management
system: thus, any person has knowledge about SQL query language because it is powerful and
effective database management. There are different technologies such as MS Access, Oracle and
SQL query language etc.
Benefits of MS Access technology-
 It is easy to install and applied.
 MS Access technology helps for completely integrate with the applications such as .net,
php and Java etc.
 MS Access store 2 GB data. It provides multi user support
Limitation of MS Access technology-
 It is harder for converted into the SQL server database. Foreign keys and their
relationships removed will corporates.
 MS Access cannot be updates and deletes operations in database.
 MS Access use temporary file and this file is restricted to maximum 2 GB for all
database.
7

 It cannot optimise in proper ways.
Benefits of Oracle-
 Oracle is helpful for supporting the large database in proper ways. Oracle is secure
process because it performs different tasks at time of transaction and other user never see
to transaction details and information. It will provide security in database management
system.
 This technology is using triggers and cursors for creating database system
 Limitation of Oracle- Oracle is helpful only for large application and which is applicable
only for large organization and business. It is very expensive.
Benefits of SQL-
 SQL technology is helpful for managing the relational database system.
 It is easy for people to lean and understand
 It is portable language and run on any platform such as laptops, mobiles phones and
 Mainframe.
 It provides the security for database SQL language is supported the object oriented programming language and also integrated
with high level programming language like Java and Java database connectivity.
Limitation of SQL-
 There is not SQL profiler.
 SQL server utilised maximum memory
 The maximum size of relational database is 10 GB.
A.C.1.3 Analyse different approaches to database design
Database design approaches are required for creating an effective database system. Marks
and Spencer uses design approach for managing, controlling the database system. It is useful for
sharing the common goals and objective. There are different types of approaches discuss in given
below:
 Top down approach
 Bottom Up approach
 Centralised approach
8

 Decentralized approach
Top down approach: Top down approach moves from top to bottom and analyse the
entire system. The system is needed for identifying the generic need and requirement. Further, it
moves from downwards towards the requirement of users. This is the best approach to firstly
analyse the details understanding of system and their operations and functionality. It also checks
the database and their values.
Bottom Up approach- This approach is opposite to top down approach because it starts
from bottom to up. In marks and Spencer, the system Analyst has responsibilities to check screen
and report. It moves downwards to check all the data that are stored in database. First of all,
bottom up approach create interface between database management systems effectively and
efficiently. (Sandryhaila and Moura, 2014).
Centralised Approach- This approach and model is useful when there are less number of
variable in Marks and Spencer. It is constructing the simple and secure database. In marks and
Spencer, database administrator is determining the system need and design database schema,
data constraints etc. it also verifies the developed database design for achieving the goals and
objective of marks and Spencer.
Decentralized Approach- This approach is useful for complex database structure. This
database is helpful for large organization because it identifies the need and requirement of
customer by operational sites. According to marks and Spencer, they have database engineer to
design the views, constraints, validations and requirement etc. (Kalinin, Sumpter and Archibald,
2015). This design is useful for marks and Spencer to achieve their goals and objectives.
Entity relationship diagram- Entity relationship diagram is show the relationship between entities
set in database management system.
Entity-Relationship Diagram-
Entity- An entity is object that store some information and it is represented in the form of
rectangle shape.
9

Action- Action is representing the operations performed task between two entities in
database management system.
Attributes- Attribute is unique characteristics that distinguish between entities.
(Source:( ER Diagram, 2016)
Data flow Diagram-
A data flow diagram is flow of information for any process and system. It can be defined in the
form of symbol, rectangle and circle. Data flow chart is useful for marks and Spencer to manage
the real time data in proper ways.
10
I
Illustration 5: Entity relationship Diagram

(Source: DFD Diagram, 2017)
11
Illustration 6: data flow diagram
(Source: DFD Diagram, 2017)

1NF First Normal Forms:
According to the first normal form, it cannot hold the values of multiple values. It only holds the
atomic value in database.
2 NF Second Normal forms:
The attributes are not part of candidate’s key and it is also known as prime attributes.
3 NF Third Normal Form:
Table arranged in 2NF form and it is not part of candidates’ key known as non- prime attributes.
TASK 2
A.C.2.1 Design a relational database system to meet a given requirements provided in the given
case study
College management is design as an integrated database system which handle different
courses in college campus (Bourqueand Bourdon, 2017). In Dominican College, it offers many
programs such as accounting, management system and computer information system. These
colleges have three different campuses: West campus offer management program, North campus
offers computing program and south campus offer accounting program.
Different features proposed are:
 Student Admission
 Student attendance management
 Staff Attendance management
 Payroll management
 user management
There are main modules used in this management system-
 login
 reports Forms
Login- Login module is important to check that the user is authorized of not. Admin provide the
correct username and password.
12

Different type of users-
 Admin
 Faculty Student
Admin – It can handle the entire management system and that has responsibility to maintain the
system properly.
Case Study-
All the given data and information maintain and store in this report. There are various types of
information stored in the form of relational database system.1. Student details2. Course details3. Attendance Details4. Section Details5. Instructor details
Entity Attributes-
Entity attributes is beacime table colunm and the actual datbase is created by this attributes.
1. Department
Department _ID
Department_ Name
Department _Contact number
Department _Email id
2. Course
Course_ID
Course_name
3. College
College_ID
College_Name
4. Student
Student_Id
Student_name
Student_Email id
13

Student_Contact no.
5. Attendance
Att_Id
Att_Data attendance
Att_Hours
6. Section
Section_Id
schedule_id
Room_no.
7. Instructor
Inst_id
Inst_name
Inst_rank
In this way, This relationship is an effective and established by primary key.
Primary is creating table to add some useful information and other hand, Foreign key is
connecting between two tables and show the relationship in table form.
14

15

Database tables-
16

17

A.C.2.2- Build a relational database system for the database design Domicile College System
using SQL database software
Table Attributes Constrains
Department Department_id
Department_name
Department_Contact no.
Department_Email id
Primary key
Course Course_id
Course_name
Primary key
College College_id
College_name
Primary key
Student Student_id
Student-name
Student_Email id
Student_contact no.
Primary key
Attendance Attendance_id
Attendance_Data
Attendance-Hours
Primary key
Section Section_id
Schedule_id
Room_no
Primary key
Instructor Instructor_id
Instructor_name
Instructor_Rank
Primary key
This table shows an effective database of Domcile college that is designed in proper ways.
It also represesents the different attributes of particular entities.
18

A.C.2.3 Apply database tools and techniques to enhance the user interface
Domicine college using MYSQL database system to manage all the details and store the
data in the form ofr database management. It can be represented in different ways such as :
19

20

21

TASK 3
A.C. 3.1 Benefits of using manipulation and query tools in a relational database system
SQL query allows to manage the entire database in proper ways and it also write
substantial code to execute tasks of optimization and planning the database management system.
SQL query is a structural query language is the most efficient techniques to build language,
manuplating the data and querying database system this Sql language is catergorize into two ways:
 Data Definition language(DDL) Data manipulayion Language(DML)
Data Defination lanaguage-
Data defination language is the most effective query language that is useful for modify and
build the structure of tables, columns, schema in database system.
Create Commands-
22

Create table Department
{
Department_id int,
Department_name varchar (50),
Department_Contact no. int,
Department_Email id varchar(50)
};
Alter-
This command is basicaaly used for change, update and modify the database in the form of table
and columns.
For adding some primary key that is constranits and file have null constraints.
Alter table department
add primary key (department_id)
Also , adding some columns in the table
add department_name varchar(50),
add department_ contact no. Int,
add department_Email id varchar(50)
For droping the columns in the table
Drop table email id
Drop: Drop Command is basically used for delete the table in the database system and also deleted
the structure and its values.
Truncate- Truncate command is useful for remove all the records in the database such as tables,
space of records. It cannot remove the structure of datbase such as DROP commmand.
Comment: This command is useful for addressing comments in data dictionary. It is useful for
delete the recores in the database tables (Barokati, Wajdiand Barid, 2017).
Rename- Rename command is change the name of data base such as table name, column name ae
etc.
Data manipulation language-
Data manipulation language is playing important role in database management system to manage
the data in database schema . It is allow to perform different operations with the help of database
objects.
23

Select: Select command is retrive the data in the database system.
Insert- Insert command is helpful for inserting the data into database management system.
Insert into Department
(department_id, department_name, department_contact no, department_Email id)
values ('45', Management, '890')
Update- Update command is useful for deleting the records in the database management system
and tables.
Update department
Set department_name= management where department_id= '45'
Delete- Delete command is useful fro deleting the record in the database tables.
Delete from department
where department_id= '45'
Above query is helpful for delete the one record in the database table and then exits. Tubricats
comamand is useto where clause and delete only few rows in database.
If no where clause used in table so that all the rows deleted in database system. Using the rollback
command options to change the table in permanenetly.
A.C. 3.2 Implement a query language into the relational database system that has been implement
I have implementing the SQL query language in this college database management
therfore, Data defination language command is useful for creations the table of Domicine College
database system.
Table: Department
{
department-id int,
department_name varchar (50),
Department_Contact no. int,
Department_Email id varchar(50)
};
Table: Course
Create table Course
{
Course_id int,
24

Course_name varchar(50)
};
Table : College
Create table college
{
College_id int,
College_Name varchar(50)
};
Table: Student
Create table Student
{
Student_id int;
Student_name varchar(),
Student_Email id int(),
Student_Contact no. Int()
};
Table : Attendance
create table Attendence
{
Attendence_id int,
Attendence_Data attendance char(),
Attendence_Hours()
};
Table: Section
Create table section
{
Section_id int,
schedule_id in(),
Room_no.int()
};
Table : Instructor
25

Create table Instructor
Instructor_id int,
Instructor_name varchar(50),
Instructor_rank int
};
A.C. 3.3 Evaluate how meaningful data has been extracted with the use of query tools
Data can be created and extracted with the help of Sql query tool. This project is also done
with the help of SQL language which is widely used in the organizations and industries beacuse it
is very efficient technique for managing, accessing the data that is store into relational databse
system.
Sql query language is based of programming lanugae which is widely used in the database
management system. There are some specifi advantages dicuss in followings:
 It is effective and portable language that is run on any platform and sevices such as mobile
phones, pc, laptops and mainframes etc.
 It is helpful for managing the relational database effectively and efficiently.
 It is very reliable and every people has easily understand and learn. Most of the
organizations used this programming language to manage the business process with the
help of large database management(Barokati, Wajdiand Barid, 2017).
 This language is work on the client side to connect with the front end applications by
database. SQL structure language is support the object based programming language ans it
also intergrate with the high level programming language such as Java applications and
Java database connectivity (JDBC).
TASK 4
A.C. 4.1 Testing and reviewing the implemented relational database system
The course management database system of Dominican College need to be tested after
implementation. The testing will help college and database designers to analyse the effect of
front end applications on effectiveness of back end operations.
Testing parameters:
The implemented database system of Dominican College must follow testing methods
which can evaluate the data integrity, consistency and durability of the database. If these
26

parameters do not meet the required standards, then it will not be possible for the college to use
database system with accuracy and safety of sensitive data. During the testing it is essential that
test data must be real time and include all possible values which may trigger database in the
future. Testing without real time data can result in system failure when suspicious data attacks in
the form of invalid data (McMinn and et.al., 2016). Real time testing will help the developers to
implement the security advancements prior to the attack. The testing procedures must test the
security concerns of database. The effectiveness of security features and response of database
against security threats must be identified at testing stage so that improvements can be
introduced if required.
Testing methods:
The designed database of Dominican College can use black box and white box testing
methods. Black box testing involves procedures which do not consider the internal structure of
database. It tests the functionality of designed database from perspective of user. Black box
testing will perform the data validation tests and determines the boundaries of input which can be
used in designed system of Dominican College. It also emphasis on determining error
possibilities so that they can be eliminated before actual implementation of database. On the
other hand, white box testing internal structure is matter of consideration for testing procedure. It
requires deep knowledge of programming so the users cannot perform it at their own level. This
testing ensures that results provided by database are as per expectations of user.
Types of Testing:
Dominican College requires database for its course management function. Thus, its
testing procedures must ensure that validity and integrity tests are also performed along with
performance evaluation and functionality tests. Functionality related test methods evaluate the
effectiveness of all functional operations. These tests ensure that only valid data is processed and
desired operation is performed on data (Clifford and et.al., 2016). The invalid data can be
suspicious and can serve as threat to security of Dominican College. Thus, during testing data
verification and validation are tested. It provides complete assurance to database designer that
data is not lost during transactions and only authorised access is permitted.
A.C. 4.2 Supporting documentation for database testing and implementation
Dominican College offers three courses in its campuses. At present college operates in 3
campuses and require allocating the campus, course and lecturer to each student. It also requires
27

coordination and interaction with faculties so that they can be assigned courses to them for
teaching. With manual methods and without any centralised system it becomes very difficult for
the college to manage these operations. Because many times allocations contradict or collide
with those made by other campus. For instance, the same professor can be given different
courses in different campus for the same instant of time. Such mismanagement can be resolved
by using centralised database system which can manage the courses. It will help college to
monitor all campuses and lecturer’s simultaneously so that better decisions can be made. The
database system will also help students to collect all information on just single click without
moving here and there without getting troubled.
The database system will not only boost the speed and accuracy but will also provide the
security to the information. Along with the database implementation it becomes necessary that
database is tested before implementation (Dimmick, 2017). If college use database without
testing, then it may happen that it does not meet the requirements of the college and
discrepancies can lead to system failure. It will result in unnecessary expenses as well as
informative records of college. Untested database system does not guarantee the accuracy as
well as security. Thus, it may have higher vulnerability towards unauthorised access and other
networking threats.
A.C. 4.3 User documentation for course management database of Dominican college
The following documentation will help Dominican College to develop better
understanding of its implemented database system which will assist it in managing its various
courses.
Administration: This tab will allow user to view details or particular student or lecturer that
in which course student has taken admission or which units are assigned to lecturer. It will
give user the authority to modify the course and lecture allocation by giving centralized
view of all campuses.
Student: To make it easy for the students to gather information this section will allow
students to review their status of fee, course as well as the details of campus and lecturer
provided to them. It also gives chat option so that students can give request for change or
modification options.
Lecturer: This section of database provide facility to the lecturer’s that they can view their
28

allocations and can request for the change. It will also provide option for them to view
other lecturers who teaches the same course.
Course details and fee structure: The users can find the course details in this option of
database. This tab will provide details such as fee structure, details of units and courses
available in particular campus and the available lecturer’s for the particular courses.
Settings: To make the user interface more easy setting options of database will allow users
to change the visual appearance of database, brightness, font size and background colors
which would enhance the suitability of database for users.
Student registration form: This option enables students to fill their complete details and
preferences for record purpose of college. Students can also pay their fees here after
completing registration.
Lecturer confirmation form: To confirm the teaching options and to modify or add
teaching preferences lecturers can use this tab in the database. It will allow only lecturers
and students will not be able to access it.
Log out/ switch account: In order to provide the secure access passwords and account
managing options are also provided.
Thus, the database system will requirements of all of its users and Dominican College.
A.C. 4.4 Data validity and verification
Testing methods also includes the parameters such as validity and verification of data.
Verification is defined as the procedure to verify accuracy of data entered by the user in
database. It also addresses the data inconsistencies which might occur as a result of data
migration. For instance, it may happen that in database system of Dominican college user may
enter name of student two times or a particular data is not included while upgrading records. It is
essential that database must have properties to verify the data to avoid errors. For instance,
implemented system gives a notification when same data is repeated. It also gives notifications
when in a particular sequence any data is not entered. This feature confirms that user has not
missed any particular entry.
Another significant term in database testing is data validation. It is important for the
administration that all users fill the correct data. For instance, the name field must contain any
sensible attributes. It must not contain any numerical or more than 100 characters (Chow and
29

et.al., 2018). There are several data validation techniques such as digit check, length and data
type check, spell check, range and presence check. It will ensure that users enter only meaningful
data. For instance, data validation will enable user to enter only correct data. In database of
Dominican college users cannot enter working hours more than 8 and if any user does that then
range check will not allow it to do so. Hence, verification and validation of data is essential for
accuracy of the database system.
A.C. 4.5 Control mechanisms in database system
Dominican college requires various control mechanisms in its database system so that
quality of its course management objective can be improved. In the development of database
mainly access control, quality management and security control mechanisms are used.
 Access control mechanisms controls and monitors that each section of database is
accessible by authorized individual's only. For instance, the lecturer tab cannot be
accessed by any student. Similarly, lecturers can access the students of particular course
but they cannot access the preferences and fee status of the students.
 Another control mechanism used in database is quality of management. If data is not
managed as per quality standards, then college may not extract benefits of database
implementation. These mechanisms ensure that only valid data is processed and data
integrity and verification are regularly performed.
 Security control mechanisms are one of the most important aspects because they aim at
maintaining the records of Dominican college secure from the networking attacks.
Without this mechanism the activities of college will always be at risk (Kumar, 2015).
CONCLUSION
Above report, it concludes that the databse management system is essential for
organization and indsutry to manage, store and access the data. This report also decribe the
benefits and limitations of SQL structured query language. Query language is helpful for design
an effective database in the form of tables. This report is using different database tools to
implements the data in to relational database system and also implemeting the query language in
relational database management system.
30

REFERENCES
Books and Journals
Clifford, A., Emanowicz, K., and et.al., 2016. Test data generation and scale up for database
testing using unique common factor sequencing. U.S. Patent Application 14/859,253.
Chow, K.Y., Lee, T.H., and et.al., 2018. Semantic database driven form validation. U.S. Patent
Application 15/713,734.
Dimmick, J., Visa International Service Association, 2017.Data verification using access device.
U.S. Patent 9,680,942.
Kumar, S., 2015. Design of multilevel secure database system enabled with efficient concurrency
control mechanism.
McMinn, P., Wright, C.J., and et.al., 2016, October. SchemaAnalyst: Search-based test data
generation for relational database schemas. In Software Maintenance and Evolution
(ICSME), 2016 IEEE International Conference on(pp. 586-590). IEEE.
Lewis, S., 2015. Qualitative inquiry and research design: Choosing among five
approaches. Health promotion practice, 16(4), pp.473-475.
Kratochwill, T.R., 2015. Single-case research design and analysis: An overview. In Single-Case
Research Design and Analysis (Psychology Revivals) (pp. 13-26). Routledge.
Baek, J.S., Meroni, A. and Manzini, E., 2015. A socio-technical approach to design for
community resilience: A framework for analysis and design goal forming. Design
Studies, 40, pp.60-84.
Taylor, R.M., 2017. Situational awareness rating technique (SART): The development of a tool
for aircrew systems design. In Situational Awareness (pp. 111-128). Routledge.
Xia, J. and Wishart, D.S., 2016. Using MetaboAnalyst 3.0 for comprehensive metabolomics data
analysis. Current protocols in bioinformatics, 55(1), pp.14-10.
Anders, S., Pyl, P.T. and Huber, W., 2015. HTSeq—a Python framework to work with high-
throughput sequencing data. Bioinformatics, 31(2), pp.166-169.
Sandryhaila, A. and Moura, J.M., 2014. Big data analysis with signal processing on graphs:
Representation and processing of massive data sets with irregular structure. IEEE Signal
Processing Magazine, 31(5), pp.80-90.
31

Kalinin, S.V., Sumpter, B.G. and Archibald, R.K., 2015. Big–deep–smart data in imaging for
guiding materials design. Nature materials, 14(10), p.973.
Bourque, C.J. and Bourdon, S., 2017. Multidisciplinary graduate training in social research
methodology and computer-assisted qualitative data analysis: a hands-on/hands-off
course design. Journal of Further and Higher Education, 41(4), pp.475-491.
Barokati, N., Wajdi, N. and Barid, M., 2017. Application Design Library With gamification
concept. Jurnal Lentera: Kajian Keagamaan, Keilmuan dan Teknologi, 3(1), pp.93-102.
Online :
Data base system, 2017. [Online]. Available through:
<https://www.tutorialspoint.com/dbms/images/dbms_schemas.png>
Relational data model, 2013. [Online]. Available through:<
http://cdn.yourarticlelibrary.com/wp-content/uploads/2013/09/clip_image005.jpg>
Source: Hierarchical data model, 2013. [Online]. Available through:
<http://cdn.yourarticlelibrary.com/wp-content/uploads/2013/09/clip_image002123.jpg>
Network model, 2013. [Online]. Available through:<http://www.yourarticlelibrary.com/wp-
content/uploads/2013/09/clip_image003.jpg>
ER Diagram, 2016. [Online]. Available through:<http://users.jyu.fi/~jpt/doc/thesis/Fig6-3.gif>
DFD Diagram, 2017.[Online]. Available
through:<http://www.modernanalyst.com/Portals/0/Public%20Uploads/Buyer.png>
32

33