Riya Verma – 240253 Unit 18 Database Design Assignment 1
P1:
Features of Relational Database:
Relational database:
A relational database (RDB) is a type of database that stores and provides access to the data
points that are related to one another. The relational database is based on the relational
model, an instinctive, straightforward way of representing data in tables.
In an RDB, each of the rows in the table is a record with a unique ID
called the key. The columns of the table hold attributes of the data and
each of the records usually have a value for each attribute by making it
easy to establish the relationships among the data points.
RDB is a collection of various data sets grouped according to the
tables, records and columns. A well-defined relation between the
database tables is recognized by the RDBs. The tables that provide and share information by
making it easier to search, organize and report data. The RDB is a standard user application
that provides an easy programming interface for the interaction of databases Structured
Query Language (SQL).
Why a database is better than a spreadsheet?
A database is identical to a computer, more specifically the database is a set of tables
arranged as a tablet in columns and rows. The distinction is that the actual columns and
rows in each database can be used, and the multiple associations between specific tables
can be done.
The collection and retrieval of the
Information are structured by a
relational database management system
(RDMS). RDMS tables logically store the
data precisely to ensure data integrity,
minimise regulations and reduce
duplication.
Some suffering can be avoided if the user takes time to think about the premise of a project
before it starts. You also consider whether to create a database or move the current table to
a database for your idea.
User access: The only explanation is that many individuals will need access to the files if a
folder is set up by several users, and they will have to operate on the same file instead of
receiving error messages that they will not have access to and will not have trouble with the
same file.
Space: A map is a perfect way to track a simple list, but will it keep growing and becoming
uncontrollable? As libraries, it is best to archive the documents with long-term
, Riya Verma – 240253 Unit 18 Database Design Assignment 1
modifications. Databases have much more storage than tablets. If the table reaches 20
columns or 100 rows, the function of a database will probably be better.
Queries and reports: A database may be the answer if you have difficulties querying certain
data sets for reports. The data is formatted and arranged for the desired report to be
printed when creating a Table. In a database, you can generate multiple reports with the
same data, separating the data and reporting functionality.
The management wants quarterly sales records for the company, the programme's manager
wants sales for its region annually only, and the marketing department wants monthly sales
by type of product. The database helps the user to use advanced queries to produce the
three formats from one source instead of keeping the three spreadsheets with different
views from each component–not the requisite copying and pasting.
Data Integrity: Another reason to get away from spreadsheets is the replication of the data.
as there may be different versions whereas the data is stored in the relational database
where the complexity and space are saved.
Main features:
Entities/tables:
The data is stored in entities/tables where it is processed. Tables can contain data
dependent on a matter or object's significance. For example, a database of tables containing
data such as a user's name, username, gender, mobile number, etc. would be applied in an
organisation. As it follows the idea of containing the information the user wants to provide.
Key fields:
- Primary keys:
Primary keys are unique numbers that provided to each person in a database (or if they
relate to the stock then each item in a stock list would be provided with a primary key).
It is then used as identification to an individual so that when customers are entered in a
database, as each of them has unique numbers when customers are called in and ask for
information, they are requested to enter their primary key number to identify them (instead
of the organisation).
- Foreign keys:
Tables are linked by foreign keys. In one table the main key is used and when used in
another table, since the key is identical, it is known as foreign keys once the key is linked
together.
An example maybe, if the user makes another table using the new primary keys and the
existing one, it's better to leave one item in that table (or customer) with the primary key
that it was given (therefore making it a strange key for the new table that it would link to
where it was issued) so that there is no confusion or a new key for that item.
P1:
Features of Relational Database:
Relational database:
A relational database (RDB) is a type of database that stores and provides access to the data
points that are related to one another. The relational database is based on the relational
model, an instinctive, straightforward way of representing data in tables.
In an RDB, each of the rows in the table is a record with a unique ID
called the key. The columns of the table hold attributes of the data and
each of the records usually have a value for each attribute by making it
easy to establish the relationships among the data points.
RDB is a collection of various data sets grouped according to the
tables, records and columns. A well-defined relation between the
database tables is recognized by the RDBs. The tables that provide and share information by
making it easier to search, organize and report data. The RDB is a standard user application
that provides an easy programming interface for the interaction of databases Structured
Query Language (SQL).
Why a database is better than a spreadsheet?
A database is identical to a computer, more specifically the database is a set of tables
arranged as a tablet in columns and rows. The distinction is that the actual columns and
rows in each database can be used, and the multiple associations between specific tables
can be done.
The collection and retrieval of the
Information are structured by a
relational database management system
(RDMS). RDMS tables logically store the
data precisely to ensure data integrity,
minimise regulations and reduce
duplication.
Some suffering can be avoided if the user takes time to think about the premise of a project
before it starts. You also consider whether to create a database or move the current table to
a database for your idea.
User access: The only explanation is that many individuals will need access to the files if a
folder is set up by several users, and they will have to operate on the same file instead of
receiving error messages that they will not have access to and will not have trouble with the
same file.
Space: A map is a perfect way to track a simple list, but will it keep growing and becoming
uncontrollable? As libraries, it is best to archive the documents with long-term
, Riya Verma – 240253 Unit 18 Database Design Assignment 1
modifications. Databases have much more storage than tablets. If the table reaches 20
columns or 100 rows, the function of a database will probably be better.
Queries and reports: A database may be the answer if you have difficulties querying certain
data sets for reports. The data is formatted and arranged for the desired report to be
printed when creating a Table. In a database, you can generate multiple reports with the
same data, separating the data and reporting functionality.
The management wants quarterly sales records for the company, the programme's manager
wants sales for its region annually only, and the marketing department wants monthly sales
by type of product. The database helps the user to use advanced queries to produce the
three formats from one source instead of keeping the three spreadsheets with different
views from each component–not the requisite copying and pasting.
Data Integrity: Another reason to get away from spreadsheets is the replication of the data.
as there may be different versions whereas the data is stored in the relational database
where the complexity and space are saved.
Main features:
Entities/tables:
The data is stored in entities/tables where it is processed. Tables can contain data
dependent on a matter or object's significance. For example, a database of tables containing
data such as a user's name, username, gender, mobile number, etc. would be applied in an
organisation. As it follows the idea of containing the information the user wants to provide.
Key fields:
- Primary keys:
Primary keys are unique numbers that provided to each person in a database (or if they
relate to the stock then each item in a stock list would be provided with a primary key).
It is then used as identification to an individual so that when customers are entered in a
database, as each of them has unique numbers when customers are called in and ask for
information, they are requested to enter their primary key number to identify them (instead
of the organisation).
- Foreign keys:
Tables are linked by foreign keys. In one table the main key is used and when used in
another table, since the key is identical, it is known as foreign keys once the key is linked
together.
An example maybe, if the user makes another table using the new primary keys and the
existing one, it's better to leave one item in that table (or customer) with the primary key
that it was given (therefore making it a strange key for the new table that it would link to
where it was issued) so that there is no confusion or a new key for that item.
