Scribd
Upload
87 views

Data Base Assignment 2024

Uploaded by

mahatodipesh623
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
87 views

Data Base Assignment 2024

Uploaded by

mahatodipesh623
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Activity 1

User Requirements and System Requirements:

User Requirements

User requirement is the requirement the user needs when using the database system. User
requirement is a document which is used in projects that describe to us the expectation.
Evaluation of the state of affairs of the user when utilizing the software. The user requirement
can be the user document or the user manual as it is primarily, documented with regard to
customers.

Documentation for Users

It is recommended that any program or a sequence of programs that make up a composite system
should have a manual. This document follows more or less the same path as the operating chart
and provides subsidiary details or amplifications where necessary instruction with the exception
that the user will not likely be as involved with the equipment. Such matters, and others of the
same nature, will also be ignored by the operator.

The user’s manual should cover:

 Function information describing the works done by the program;


 The ways through which the user feeds the program-data to be processed or not to be
processed, covering format analysis and the material and content of the data as well as the
limitations imposed on values such as, and so on (Database Design And Development, 2020)

System Requirements:

Systems requirements offer a detail account of the features that a system has to offer. It also
gives details of the services and the constraints that may be encountered in precise terms. Also
commonly known as the functional specification, this document represents a highly important
work tool which effectively acts as a passport of that system, a sort of contract between the
system’s buyer and its maker. In essence through well-defined expectations it makes up for
communication and comprehension, directing the development process so that the end product
meets the user expectations as well as the performance requirements.
Fig : System Requirements

Relational Database System:

A relational database is a combined designed system in which data is divided and arranged in
tables with different names and columns. In each row we have there record while the column
contains various factors which relates to that record. One important principle of the relational
databases is the capacity to define relationships between tables, and thus, perform rather
complicated requests and analyses: for instance, connecting a given customer table to an order
table, in order to determine which of the customers has ordered what. The databases used in this
work are built on the basis of the mathematical model of relational algebra, which enables the
effective manipulation and querying of the data. However, even today when more and more
specialized NoSQL solutions have popped up, relational databases are still the most popular due
to the fact that they can still meet many different data and application needs. (Bentil Shadrack,
2023)
Fig no.1: Entinity Relational Database Of intro…..

Why is it important:

It is important because relational databases store data in organized tables so that data will be
accurate and use SQL to tackle preserve complex queries. They all have effective, secure and
robust transaction support which makes them preferable in very many cases. Here are some
benefits of Relational Database:

 Data Integrity: Consistent relationships are made compulsory by constraints such as the
foreign keys and ensuring uniqueness by means of the primary keys.
 Data Security: Aids in security measures consists of: access authorization and the encryption
on important data.
 Scalability: Relational databases are called type 2 databases because they can prove as
candidates for large data volumes and can also be scaled up for future business needs.
 Normalization: They achieved data redundancy reduction by the method known as
normalization, thus improving the way data is stored and managed.
Logical Diagram:

Fig no2: Logical Diagram


Data Dictionary:
According to (GeeksforGeeks, 2024) Data dictionary is an indispensable component of a Database
Management System (DBMS) as it contains summarized information about all entities within the
defined database. Information concerning its table characteristics and definitions, fields and data
types, constraints and relationships between tables are part of it. While used primarily as an
index to either a physical or electronic data, the data dictionary summarizes all the data to
improve its organization and quality, assist in the communication of the data, help new users
understand the data, and support the compliance with data laws and regulations. Finally, it acts as
a relevant basis for organizations needing data analysis for decision making purposes.
Interface Design and Output
This also describes how concerning about the basic and complex interfaces in the different
related database systems and forms has been used to complete the above-mentioned interfaces.
Five forms are used to give the best design and output that can be relevant to United Limited’s
correct results.

Login Table
Signup Table
Customer Table
Booking Table
Room
Amenities

About Us Form
Data Validation Mechanism

Data Validation is a process of verifying that source data is clean and of a sufficient
quality before using, importing or otherwise processing such data. Based on the
destination constraints or objectives, it is possible to carry out different form of
validations. They put validation as a type of data cleansing. When there is change or
transformation of data from one system to the other, or there is combination of data from
multiple systems, then it is very important that the data reflects adherence to business
rules and not contain conflict in data-type or sense. To this end, a goal is adopted that
ensures that data is produced which is comparable, truth worthy, and free from gaps to
ensure that the move does not cause loss or distortion of data. It is good to confirm data
accuracy, quality and specificity to control for project deficiencies and make decisions on
well-informed information. Validation techniques sanitise datasets, remove unwanted
files, and give proper format for the best output. The final operation in this context is
important in Data Warehousing and ETL, enabling analysts trace data conflicts. Some
inputs here may be wrong, but a wrong model will create problems in all applications:
Hence, it is better to validate the inputs and the model both. Data validation can be
applied to any data or in some sorts of applications such as MS Excel or in the data
storage.

Types of data validation mechanism

References:

Tutorsglobe.com. (2022). Tutorsglobe. [online] Available at:


https://www.tutorsglobe.com/homework-help/software-engineering/user-and-system-
requirements-7714.aspx [Accessed 20 Oct. 2024].

‌Bentil Shadrack (2023). Why are relational databases useful🤷🏻‍♂️. [online] DEV Community.
Available at: https://dev.to/documatic/why-are-relational-databases-useful-307p [Accessed 20
Oct. 2024].

‌GeeksforGeeks (2024). What is Data Dictionary? [online] GeeksforGeeks. Available at:


https://www.geeksforgeeks.org/what-is-data-dictionary/ [Accessed 23 Oct. 2024].

You might also like