× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
New Topic  
EnS0urce EnS0urce
wrote...
Posts: 680
Rep: 0 0
6 years ago
How does a DBMS that follows the relational model handle entities, attributes of entities, and relationships between entities?
Read 43 times
2 Replies

Related Topics

Replies
wrote...
6 years ago
Entities and attributes are fairly simple. Each entity has its own table. The attributes of an entity become the columns in the table. In a relational model database a one-to-many relationship is represented by using common columns in two or more tables. More formally, a relation is essentially a two-dimensional table. Each column in a table should have a unique name, and entries within each column should all match this column name. Also, each row (also called a record or a tuple in some programs) should be unique. After all, if two rows in a table contain identical data, the second row doesn't provide any information that you don't already have. In addition, for maximum flexibility in manipulating data, the order in which columns and rows appear in a table should be immaterial. Finally, a table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a repeating group) in an individual location in the table.
EnS0urce Author
wrote...
6 years ago
White Heavy Checkmark
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1258 People Browsing
Related Images
  
 122
  
 267
  
 1037
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 352