Data Analysis and Design: A Relational Database System for Dominican College

This report delves into the design and implementation of a relational database system for Dominican College of Blauvelt, focusing on data analysis and design principles. It explores various data models, their benefits and limitations, and the process of designing a relational database management system (RDBMS) to meet specific requirements. The report includes detailed documentation of the database design, including entity-relationship diagrams, data flow diagrams, and table structures. It also covers the implementation of SQL queries for data manipulation and retrieval, as well as the testing and validation of the database system. The report concludes with a discussion of the outcomes and the importance of verification and validation in ensuring the reliability and security of the database.

Data Analysis and Design
Lucian Melecciu
Lecturer:
Campus: Wentworth House
Course: HND Computing and System
Date:

Contents
Preface........................................................................................................................................................2
Exercise1.....................................................................................................................................................4
1.1 critically compare different data models and schemas.....................................................................4
1.2 Benefits and limitations of database technologies............................................................................9
1.3 Approach to design database: -.......................................................................................................11
Exercise2...................................................................................................................................................13
2.Relational DBMS design in contradiction ofrequirement...................................................................13
2.2 Build Relational Database system based on design........................................................................18
2.3 Tools of Database to enhance user interface..................................................................................28
Exercise3...................................................................................................................................................30
3.1 Ease of query tools and manipulation.............................................................................................30
3.2 Implement query language into RDBMS..........................................................................................32
3.3 Estimation of extracting meaningful data........................................................................................38
Exercise 4..................................................................................................................................................40
4.1 Criticallly review and Test a Relational database system.................................................................40
4.2 Create documentation to support the implementation and testing of RDBMS...............................41
4.3 User Document for developed Relational Database System...........................................................63
4.4 How verification and validation has been addressed......................................................................74
4.5 Mechanism of controlling................................................................................................................78
Outcomes..................................................................................................................................................80
Resources..................................................................................................................................................81

Preface
This report is based on Data Analytics and their design. This report designed for Dominican
College of Blauvelt which is situated near New York. Dominica College offer various courses in
the field of science, art, healthcare, and commerce. College is cited near Rockland country, New
York. College offer various Bachelor’s and Master Degree program. Dominican college started
with teaching with underprivileged student after few years it become a coeducation college
which has courses like Social welfare, nursing, athletics, psychology etc.
This project shows the data Analysis of college data where data is menu plated to show the
basic operation like selection, data insertion, data fetching, data deletion, etc which is done
using simple command of SQL. Data base is made easy access of data which is done to make
large data access for big organization easy.

Exercise1
1.1 critically compare different data models and schemas
Data model is used to use to document the database design which makes a complicated
software design simpler to be understandable easily. In below section it is defined the data
model of different type.
1. Hierarchical data model
Hierarchical model is a kind of data which is organised in form of tree like structure. That
structure is also known as top down approach which has top most data item is known as root,
and rest are child of that root, that root child can have more sub category or sub child which
will can have their sub category or sub child. This root child relation will be the consider as
relation between data with hierarchy.
2. Network data model
Network Data model Is a kind of Data model which allow user to connect to the another
with by giving the flexibility of data sharing or exchange. This data sharing is can be faster
using network data model as it allows the user to have a sender and receiver relation which
categories the process of transfer of data which is at a time sending or receiving. A sender
can have as many receivers wanted to share data. That multiple sharing is possible by the
ability have data relation with multiple client source. Data transfer in the form of images,
text, document etc.

3. Relational data model
Relational data model is popular and common kind of data model which is used too access
data in the form of relation like one client to many clients, many clients to one client, many
clients to many client, one client to one client etc. This data model consists of raw and
column which is also known as tuple, tuple or row which can be data regarding a specific
information which is needed to the client. That specific information can be an account
number or unique id which is needed by the client. Data model can have data in form of
combination of different information.

4. Entity-Relationship data model
This model is used to model the logical view of the system. It is the entity-relationship
model in which an entity may be an object with a physical or a conceptual existence such as
a particular person, a company, a job. The set of all entities is called entity set for example-
E1 is an entity having employee entity type and the set of all employees is the entity set.
Comparison of data models are as follows:
Characteristics Hierarchical Model Network Model Relation Model
Data structure This model allows
one to one and one
to many
relationships.
It allows many to
much relationship.
It allow one to one,
one to many and
many to many
relationship.
Based On It is based on parent
child relationship.
Can have many
children’s and many
parents.
Based on relational
data structure.
Data Manipulation Algorithm for
retrieve data is very
complex and
asymmetric.
Algorithm for
retrieve data is
complex and
symmetric.
Retrieve algorithms
are simple and
symmetric.
Data integrity Child who does not
have any parent
There are no
insertion anomalies.
There are no
insertion anomalies.

cannot insert data
When we update
the child record who
has multiple
occurrences leads
the problem of
inconsistency.
This is free from
updation anomalies.
This is free from
updation anomalies.
If we want to delete
parent record also
deletes the child
records.
There are no
deletion anomalies.
There are no
deletion anomalies.
Data independence
Data independence is a concept by which data kept isolated from the using software or client
information source. Independency refers to data logic which help data to be immune from the misuse of
it, it will be used by the application only on need but it will be kept away.
1. Logical Data Independency: Logical data indecency refers toa logic which is used in mapping of
the data that is done by the combination of record or record into the single record or dual
record.
2. Physical data independence: Physical data independency is physical database used to store data
without overlapping or damaging the existing data model.

Data redundancy-
Data redundancy is repetitions of data without help of any other data that superfluity is the of data.
Data redundancy is a concept which helps to understand the multiple data for same data which is
already inside the database. Redundancy is word which represents a single data which is present in
different place. If database has more data it will work slower which is avoided.
Data integrity-
Data integrity is a concept which allow the client to assure that data is provide is secure. Data
has run in cycle which is safe that mean data is built in such a way that it difficult to misuse.
Data integrity is a parameter which allow user to establish the network which is used to detect
the data is secure or not.
Database Schema
Data schema is defined as the orientation of data which is used to structure the data which help
to identify the user of data which is known to the database identification schema. It defines the
use of data which is used in view of entire database.
1. Physical Schema
It refers to the physical database record which helps to identify every bite of data which is used
in installing the database internal data.
2. Conceptual/Logical Schema
In this schema the data is used to identify the storage of the product which has specific domain
in which the data is stored.
Tables fields relationships
A table is formed by the column and row which are the basic building blog of the table. Table
field relations are the used by the client to access data from the database. Table filed have a
key which help to identify specific data from various data which are inside the database.
Views
View is a help to display data on client machine. Database is the for of raw and column which is
confusing for client so view display the data in such a manner that client has ability to view data
in user intractable manner.

Data dictionary
Data dictionary is used in database identify the necessary data from the database. Database has a lot of
data which is difficult to identify by the client and the one who use it so data dictionary help to identify
the necessary data from the lot of data. Data is enormous amount then it is impossible to pick our
specific kind of data then data dictionary help to identify the necessary data from the database. This
kind of database is difficult to search.
For example
1.2 Benefits and limitations of database technologies
First I have defined what database technology is then I have listed the benefits and limitations of
database technology.
What is database technology?
Data base technology is a used to work on data which include creation of database, updation of
database, data base editing and database distortion. Database is technology help to identify the
database which is used to identify the data from the heap of data. Database technology is used to
identify the data which is used to identify the data.
Database is totally depending on computer-based record through data can be retrieved and maintain
easily
Different type of data models are listed below:-
Relational database: - Relation database is used to implement database logic which is used to pick the
data which will be get by the database from the hep of database. Relation help to get database with
reference to other as a key and by this category of database. Database has its own category which will
help client to get data.
Distributed database: - This is data type which is homogenous (DDS has same physical locations, same
hardware, which help in same operating system) and heterogeneous in nature (DDS has different-
different physical location, Hardwar, operating system) or we can say vice versa.
Multi-dimensional database: Data help to identify the data from the data from the heap of database
which will help to get the data from the database. In multidimensional data to identify the entity from
the database.
Object relational database: - In this entity has dependent on other entity directly support object, classes
and inheritance are and database schemas. Data model support extension of the data with custom
data-types and their methods.

Object-oriented database: - it is commonly known as (OODB) which is use to subscribe to a model with
information represented by objects. OODB are offering opportunity in the RDBMS fields. It is used to
identify the data from the source where it created.
Multimedia database: - Multimedia help to transfer different type of data which help to
represents images, video, message, etc. and multimedia database include these media may be
one or more. These are primary media, multimedia has ability to represent may kind of media
which may be of any part of world.
Intelligent database: - An intelligent refers to database which can identify similarity in database
by its own and can answer query which is asked by the user by checking into its database. It
replaces traditional and old hand-written data which need to check and add data manually.
Data warehousing: - A process which help to store data, it is a manner for managing data and collecting
data from different sources to facilitate business observation. Data is stored in the in category which is
used in easily identify bulk data. Basically, it can store or save huge quantity of information by a
business.
Data mining: - Data mining is process by which raw data is converted into useful data by
extracting it and converting it into required categories, once category is made then database is
used as required.
Benefits:-
Efficiently using the database and managing it.
Improved productivity.
Reduced paper storage which makes is long lige storage
No need of printing or paper.
Safety on backups.
More efficient fetching and retrieving reporting.
Increased productivity.
Improved security of data.
Reduced the redundancy of data.
Reduce the cost of data entry, retrieve and storage.
Limitations:-

Complex to design.
Size or we can say large pieces of software.
Higher impact of failure because vulnerability is increases of the system.
Addition of hardware cost and maintained.
Cost in recovery.
Substantial hardware and software cost of start up.
1.3 Approach to design database: -
Decentralization of database design: - Decentralization of data is the method by which data is
used to create the separate layer in which will be away from the access of unauthorizes access.
Top-Down database design Approach: - It is kind of data approach which is mainly used to
make a new database. We First perform the task of modelling of a logical level is necessary
after that physical database design comes. Foe instances: A database would rather need the

objects to be mapped to tables. It is commonly use to transfer a database from one physical
database to another.
Bottom-Up database design Approach
It is kind of approach of data which it is basically starts with a common idea of according to the
need of system and afterward of data which help to perform task of data which do questioning
to the end-user what data should be stored data. It is starts from the basic details and moves
up to the general. The system has checking reports, screens, and forms.
(Cs.montana.edu, 2018)

Exercise2
2.Relational DBMS design in contradiction ofrequirement
Entity Relation Diagrams (ERDs):
The database entity and the relationship between them are represented by entity relationship diagram.
It is used at the time of documentation of project. It helps the developer to create database. When a
developer will create a database then he can easily understand to see the ER- diagram. It will show that
which elements will primary key and which will be foreign key.
Determinacy diagrams:
It provides mechanism to developer for creating database for any project. It shows that how database
will be looked. It gives the complete detail about the structure of database that will be create.
Data flow diagrams(DFD)
The diagram that will show the data flow of database that means how to data will be flow, how the data
will be relate to one database to other is known as dataflow diagram. It is the first step that will show
the developer as well as user before the development of the database.
Entities:
Entities are real world entity that will be used in database. The entity has its own uniqueness. Entity may
be anything that will be used in real world like as student, teacher, school, college, contact etc.

Attributes and key identifiers
Attribute is the word that will define entity Like as a student is an entity and the name, class, branch, roll
number, contact, address are the attribute of student. It defines the identification of students. It defines
the quality of entities. An attribute may have multiple attribute.
Relationship types
It includes how much type of relationship may possible between two or more entities. We create the
relationship between two tables by using foreign key. These relationships will be denoted by its name.
These relationships may be single, double and triple.
Kinds of Relationship:
1. Single relation: -an entity type linked with it also called single or received relationship.
Example: - room-mate, where student is linked with student.
2. Double relationship: - it is a relationship where one that links with the two entities sets.
3. Triple relationship: - Triple relationship is that involves three entities. Example: - student
v/s class.
Functional dependency

It is a type of relationship that creates when one of the attribute uniquely determine other attribute. It
is the relationship that shows the dependency of functions.
Normalization
It is used to remove the redundancy from database. It is one of those most important rules of database
that will be use during the creation of database. It stores data in a relational theory. It promotes the
ACID property for database.
It is used to store a meaningful data in the database. By using the normalization theory we cannot insert
any random value in database.
There are four type of normalization concept that will use in database. These normalization forms are 1 st
Normal form, second normal form, 3rd normal form and BCNF. These are described below:
1. 1st Normal Form: In this normalization only atomic value will be Inserting. No multi-
values can exist in a single column or a row after applying this phase a new relation in
found and this is known as relation in 1st normal form.
2. 2nd Normal Form: It follows the concept of 1st normal form and single column primary
key. The redundancy of data i.e., is unnecessary expressed multiple time in the relation
or depends only one part of multivalued key.
3. 3rd Normal Form: It will follow 2nd Normal form and has no transitive functional
dependencies. A relation in 3rd NF if it is in to the NF and no transitive functional
dependency exist in the relation.
4. Design of form
In this we design form in MS access and used it in database creation. It shows that how
database will be inserting in database. How data will fetching from the database. To understand
the database concept we need to create form using MS access.

Figure 1 Lecture Course Allocation Form
Design of Table

For creating the table in database 1st we click on the table create tool and save it with the
relevant name. After that we insert the field with their appropriate data type.
Query design: - Tap double time to open wizard query
Then select query design to select whole information about the college.

Database Design
Database design is the backend of any project. Any website, social network etc. cannot work
without database. During the designation of database we need to remember some concept and
protocols of database that will be very important for the creation of database. Database must
follow the concept of normalization, integrity and data redundancy.
Relational Database design of proof is explained below:
Entity relationship diagram for the Database12.accdb
2.2 Build Relational Database system based on design
It is the relational database management system. It manages the relationship between
databases. In RDBMS data will arrange in tabular form. The entire data will be in the form of
row and column. The form of some queries is listed below to design basic form:-
Selection of Database
To mention a Dominican faculty information, 1st we've to require Microsoft access information.
Information is everything however it's little tough to introduce, maintain, etc. it offers additional smart
stock then ancient information. Therewith is additionally offers the additional users supposed to the
information and in forthcoming if the client’s must recreate the information or need any alteration in
decibel. So, we've taken Microsoft Access information for making building block of the information.
Purpose

The main purpose to create a database is to design a dynamic web application and website. We
can change anything in website at any time. The database must be secure and efficient in use.
Whenever any of students will insert the data then it should be easily inserted.
Development of table
Created entirely the database tables relate to name by which consumer can correlate without
relatively a bit of an extended look into which data should setgone.
Tbl_student
Tbl_lecturer

Tbl_course
Tbl_course

Tbl_level
Tbl_unit

Unique and primary key is define for the database.
Establish relationship
For the ease of client tables get there particular outcomes from the database. Where all the
database with the one kind of of key or esteem is characterized.

Query
Here design, developed request to enquire query table counter to entire set of needs.
Query1

Query2
Query3
Query4

Query5
Query6

Form
I have developed all the form to register student, lecturer teaching confirm and other to fulfil
requirements which are as follows:
Tbl_studentform

Lecturer_Teachin_confirm
Student_registration_Form

Review
After, creating the database completely I have checked it functionality. The functionality of the
database is working properly. The data is inserting quickly and fetching successfully. The
customer says about the it is user friendly and work efficiently.
2.3 Tools of Database to enhance user interface
Tool which be used to develop the client side interface are described below:
Inputs Control:
The tools that will be used for the insert table in database are known as input control tool. It
includes text box, button, check box, radio button, text area etc.
Navigation Components:
The tool that include menu bar, logo, search, slider etc. is called navigation components.
Informational Components:
The components that will use to show the information about the database is known as
information components.
Container:
The tool that includes component of database is called container.

MySQL Workbench
It is an open source database that is freely available for every person. Anyone can easily
download and use it. Most of local companies use it for their database management.
DB Master
It helps to automate the database every day. It is used to focus the database problem, create
custom reports, and share information between all the team members via easy to understand
online tool.
PHPMY Admin
PHPMY admin is an open sources which has the ability to deal with any database measures. It is
a superb and powerful among all other stages permits to build up a database.
MYDB
It is a complete collection of tools for mysql server administration. It is also a kind of data
named MYDB which refers to an platform which provide flexibility to develop database which
offers less complex Graphical user interfaces and simple to utilize include that improves the
capacity of designer and clients. It provides fast database access service.
Oracle DB
It is the best database management system of any organization. It was developed by Oracle
Corporation. It is the most secure database of the world. It is a platform which provides
functionality to develop database. This database is used in high level multinational company.
Exercise3
3.1 Ease of query tools and manipulation

Queries in database are used to retrieve particular information like to retrieve the record of
particular student.
There are many types of predefined queries available in database which is as under:
5. Drop- It is used to drop tables, views and databases from the relational database. For
ex- Drop table student;
6. Truncate- This SQL command helps to delete records from the table of the database. For
–ex:- Truncate table student1
7. Comment- Comment is used to make any line of sentence comment so that the new
designer easily understands the code.
8. Update- It is an SQL command used to make changes in the database or to update any
column or row of table in a database. Syntax:
9. Alter

10. Insert
11. Create
The advantages of manipulation and query tools are as under:
1. These tools are used to provide security to the large set of database.

2. It offers to set up an association with help of key concept.
3. It provides benefit such as at single instance of database there can be many admin
panel.
4. It is used to fetch necessary and required data from the large set of database.
Insert query syntax:
Update query syntax:
Delete query syntax:
Create query syntax:
Drop query syntax:
3.2 Implement query language into RDBMS
I have use SQL as query language. I have listed all the DDL and DML commands below.
Relational database is the best model of database which I was chosen for the Dominican
College. In this model there are various types of options available for the user according to their
requirement. Structured Query Language commands are used to retrieve the information.
RDBMS provides various tools for solving the problems.
Development of Query:

For run the query in MS-ACCESS first click on Query wizard. In this wizard there are many query
tools for run the query. Design View in this wizard is used to retrieve data from one or more
tables of the database by right clicking on that table and then perform the JOIN operation to
get the information.
Query1
Query2

Query3
Query4

Query5
Query6

Query7
Select the design wizard and then design forms for running the query7 and query8.

Query8

3.3 Estimation of extracting meaningful data
Necessary data is extracted with the help of Structured Query Language or SQL. There are
various languages inbuilt in SQL through which many commands can be perform for getting
meaningful data from the database. All these commands have their own syntax to perform the
desired action. Commands are the basic building block for retrieving the desired and
meaningful data easily.
DDL
The DDL refers to for Data Definition Language. DDL is used to define the data structures. This
language commands are basically used to update and create the structure of the database
objects like indexes, views, tables etc.
DML
DML is used to manipulate the data with the help of some manipulation operations. Some
operations which comes under this language are select, insert, update, delete, merge, lock
table, call etc.

To retrieve meaningful data from the database Dominican College admin may use following
syntax:
Select Query
In this part retrieving we will fetch the data of lecturer by taking name and course which he is registered
for from the database. Now I will show you by performing the query.
Select Query

To extract the data of course name and course fee, I have run the select query.
Exercise 4
4.1 Criticallly review and Test a Relational database system
Any organization uses the database and many users use this database any insertion, modification,
deletion into database will affect all the data of all users. So we ensure that database procedure, trigger
and high level functions database must go through a rigorous test cycle. Testing will assertion that data
base is secure, bug free and reliable. And ensure that modification, insertion and deletion done
efficiently.
Records integrity: - integrity phrase refers to faith which can be saved in something. A record integrity
refers to facts is reliable or not.
We need to test database because
Because of many users uses database it contain vital data.
Identify the authenticate user for security of data.
Database must contain the reffential integrity constraints such as cascade, delete etc. While performing
the different operations in database. If we perform any operation it must checked which row is affected
by this operation.
Database must checked all the default values of database.
All the fields of the database must validate because no unnecessary data stored. And size of field must
be validated.
All data from application form must properly stored the data in database.
If we perform any operation from front end and interface corresponding action take place at backend.
to verify correct operations is performed on database while perform testing operations.
Following screenshot shows that my update query is working.

4.2 Create documentation to support the implementation and
testing of RDBMS
To implement and testing of RDBMS we create the document there are five tables tbl_course,
tbl_lecturer, tbl_student, tbl_unit, tbl_level.
 Tbl_course (course_id (pk), course_name, course_fee, campus_name).

 Tbl_lecturer (lecturer_id (pk), name, address, contact, email_address, course_id,
course_name).
 Tbl_student (student_id (pk), student_no, student_name, address, contact, course_id,
course_name).
 Tbl_unit (unit_id (pk), course_id, level_id, unit_name).
 Tbl_level (level_id (pk), level_name).
On this phase I will speak about the implementation and trying out. I’ve implemented the
database the use of MS access. After, developing the database I’ve examined it. The database is
enjoyable all the protocols of database. The records are inserting in database and the end result
effectively fetch after making use of the question.
Tables
Tables are made with the aid of deciding on design view and then click on table alternative. This
can provide numerous categories of tables and with the aid of right click select specific desk. All
instances the tables are created by means of following this technique.
Coursetable:

DB_Lecturer:

Unit of DB:

Student table of DB:
DB Level

Defining Queries
Queries are the sentences write for changing some data of the table of database like drop table,
insert into table, update the table etc.
Query1

Query2:
Query3

Query4:

Query5:
Query6

Query 7
Query 8

Query 9

Query 10

Query11

Query 12

Query 13

Query 13

Query14

Query 15

Test model
1. White Box testing
In this kind of checking out the actual code of statistics is being tested via the tester. It
is also called the code-based trying out. it is based totally on an evaluation of the internal
shape of the device. on the foundation of analysing inner shape based totally on the
code insurance, the check cases are calculated.
2. Black Box testing-.

This is additionally known as the attention-to-eye trying out. it is a checking out approach in
which the tester analyses the capability of the software without conscious very lots
approximately the internal design of the object.
Review of Chris
Chris is an worker work as an government manager in a agency examine the developed
machine and finish that each one the table characteristic consist appropriate statistics, queries
works perfectly as in line with requirement and shape best take delivery of access if all records
is correct. But he makes a recommendation that there's no any security like login panel for
having access to of database.
Sam’s Review
Sam is working in an automobile company analyse the database and commence that all the
tables and form is designed perfectly and queries give their result accurately in minimum time
that will eliminate the use of paper work.
Testing of forms
All designed form is tested by running the form and entering data into the designed form. The
testing proof is as follows:
Table showing student form details

Lecturer teaching Confirmation
Registration Form of student

4.3 User Document for developed Relational Database System
There are five tables in this database name as tbl_course, tbl_lecturer, tbl_student, tbl_unit,
tbl_level.
 Tbl_course (course_id (pk), course_name, course_fee, campus_name).
 Tbl_lecturer (lecturer_id (pk), name, address, contact, email_address, course_id,
course_name).
 Tbl_student (student_id (pk), student_no, student_name, address, contact, course_id,
course_name).
 Tbl_unit (unit_id (pk), course_id, level_id, unit_name).
 Tbl_level (level_id (pk), level_name).
I have showed all the screenshots all the tables below.
With the help of this report a consumer can without problems apprehend the complete
database.

Help Menu:
The help menu presents help to any trouble face by way of the person. For growing a database,
a person has to pick out new database after which pick blank laptop database from the
database wizard. A seek choice also to be had to the person to look for any question.
Pop-Up- Pop-Up message is generated on window screen if a user wants to rum form with
opening the SQL view of queries but if a user wants to run query, form or table then they just
has to tap twice. For getting optimum result a user have to run queries in a one by one manner.
Table
Tables are created for storing unique form of facts of attributes of the database. first, a person
has to pick favoured kind of table after which open it by means of double taping. there are
unique kinds of attributes may be assigned by using the consumer like path call, pupil
identification, path identity and access these by way of using the queries of the database.

DBCourse:
DB Lecturer:
DB Unit:

DB_Student:
Queries
Queries are like simple sentences made by the user for getting desired result of the particular
action. There are many types of queries like update, insert, delete etc. all have their own syntax
to perform and generate result.
Query1

Query2:
Query3

Query4:
Query5:

Query6
Query 7
Query8:

Query9:
Query 10

Query 11
Query 12
Query 13

Query14
Query 15

Query 16
Query 17

Query 18
4.4 How verification and validation has been addressed.
Verification and validation are the process to check whether the system fulfil all the requirement and
the purpose or objective of system. Verification is done at development phase when we developed the
database and check is it fulfils the entire requirement. Validation applies after the development to check
is it fulfils all the requirements of the customer and work as customer requirements. Verification is the
process to solve all the problems, error and bugs in development phase. Whereas validation perform
after development to check is it fulfil the business needs or not.
The process of addressing verification and validation in database development approach are as follows:

I have select the lookup wizard and select text box only on form design.

Maskinput
Input is on correct form, can’t be in letter instead of number
If any user can enter a wrong information then the conditions say that please enter right
information. Information is rather anything like his/her name last name etc. and if anyone can
left the blank boxes then alert message will appear to fulfil whole boxes etc.
User can only fill the blanks about their information they can’t going through the changes. They
have the only right to write and read only.

Validation criteria
Using validation we have selected student name because name can be going to store number
and where the lecture id no one can store text.

Anything can be entered, but only specific values are accepted by Access
(Simpson, 2018)
4.5 Mechanism of controlling
Control mechanism is DBC.It is a particular back give up laptop that's able to maintain
information 1 kilo bytes in length and guide different facts model like hierarchical, attribute
based, relational fashions.
Making plans- planning may be very shall in each steps because it always will increase the
efficiency and effectiveness. So right here first we adopted the making plans of each and every
step.
In this commonly used to test the requirement of the main manipulate mechanism because it
does permit to song the efforts and manner of employees after execution will increase the
income were given through database.
it's miles a sort of mechanism which help to recognize better the facts approximately the
procedure of development which means the statistics base developing level, education which
refers to the training technique by which easily recognize the profit, a way to estimate it, others
and the return after implementation of machine. This is useful to test the implementation is

right or terrible. Itassists to estimate the profit was given and help to estimate the destiny
earnings.
The controlling mechanism is used to permits to strictly test workforce interest and restriction
get entry to on specific region of database to govern the problems and vulnerabilities. like for
Dominican university the admin will capable to get entry to in complete database however the
person of the database can handiest get right of entry to the define region.
Budget
S.No Assets Price
1 PC’s-1 $300
3 Operating-System-Minimum required
Window7
$200
4 HardDisk has- 256MB $250
5 Random access memory- 500MB $150
6 Total amount $500
Work Breakdown Structure
Stage of WBS Start Date End Date Status
Requirement
Examination
31/3/2018 05/4/2018 Accomplished
Design view 06/4/2018 13/4/2018 Accomplished
Development process 14/4/2018 30/4/2018 Done
Testing 01/5/2018 05/5/2018 Accomplished
Maintenance
overview
06/5/2018 08/5/2018 Finalized
Update check 10/5/2018 15/5/2018 Finalized

Outcomes
The estimate of database is basically development for the Dominican university to lead all 3
branches which are indexed beneath:-
Student detail, publications, allocation, of the courses of the student and lecturer is properly
deafeningly.
For completing the estimation the database management device and database may be very
crucial because it's miles very useful and powerful cum green.so through using all of the
relationships, tactics in database it leads to present a hit effect. Many things is followed to
proving the whole database like entity members of the family version, contrast between all the
models. We’ve used on-line resources too to recognise how designing table is done, query
performed and the way to make designs in MS get right of entry to. I also used useful and non-
functionally requirement for the database. And the database is efficiently represented and used
through the described state of affairs.

Resources
Elmasri, R. and Navathe, S. (2017). Fundamentals of database systems. 1272 Seiten: [Verlag
nicht ermittelbar].
BHATTACHARYA, A. (2016). Fundamentals of database indexing and searching. [Place of
publication not identified]: CRC Press.
Horowitz, E., Sahni, S. and Mehta, D. (2007). Fundamentals of data structures in C++. Summit,
NJ: Silicon Press.
Bestavros, A. and Lin, K. (1997). Real-time database systems. Boston: Kluwer Academic
Publishers.
Euromicro Workshop on Real-Time Systems. (1997). Los Alamitos: IEEE Computer Society Press.
Eliot, G. (2016). The mill on the Floss. New York: Open Road Integrated Media.
Siau, K. (2002). Advanced topics in database research. Hershey, Pa.: Idea Group Pub.
Ramakrishnan, R. and Gehrke, J. (2000). Database management systems. Boston: McGraw-Hill.
McFadden, F., Hoffer, J. and McFadden, F. (1994). Modern database management. Redwood
City, Calif.: Benjamin/Cummings.
Siau, K. (2003). Advanced topics in database research. Hershey, PA: Idea Group Pub.
Docs.oracle.com. (2018). Introduction to the Oracle Database. [online] Available at:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/intro.htm [Accessed 27 May 2018].
Docs.oracle.com. (2018). Introduction to the Oracle Database. [online] Available at:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/intro.htm#i60808 [Accessed 27
May 2018].