I have a few Database questions I need your help with : Question 1: Why is the r
ID: 3878562 • Letter: I
Question
I have a few Database questions I need your help with :Question 1: Why is the relational model important?
Question 2: List the characteristics a table must have to be considered a relation. I have a few Database questions I need your help with :
Question 1: Why is the relational model important?
Question 2: List the characteristics a table must have to be considered a relation. I have a few Database questions I need your help with :
Question 1: Why is the relational model important?
Question 2: List the characteristics a table must have to be considered a relation.
Explanation / Answer
If you have any problems, let me know in the comments and i will try to solve them.
The relational model is implemented in the design of every commercial database in the world. In this model tables are structured to contain information which is a single data. This data is then organized in columns grouped together (having the same type of data) according to the rules that you define.
It is so widely used because of :-
FLEXIBILITY
As the amount of data increases, the model becomes more flexible and extensive due to it being scalable in nature.
SIMPLICITY
The design of this type of database is simple and easy to understand. Especially for people familiar with excel sheets, but, is not hard to pick up even for beginners because it contains identifiable structure of rows and columns.
EASE OF DATA RETRIEVAL
Since a model containing a tree structure is hard to navigate and index information from, being a table structure, makes it possible for the end user to easily retrieve data.
NORMALIZATION
This model reduces confusion by providing a set of format and guidelines for creating the database all around the network therefore known as the process of normalization.
The characteristics that a table need to follow or have are:-
ROWS having records of the entity
COLUMNS having attributes of the entity
CELLS that old the value of this entity
UNIQUE NAME for the columns
However, the order of the rows or the columns are unimportant.
Hope this helps...
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.