+1 vote
73 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

A table is in first normal form (1NF) if and only if all columns contain only atomic values, that is, each column can have only one value for each row in the table.  

Relational database tables, such as the Sales table, have only atomic values for each row and for each column. Such tables are considered to be in first normal form, the most basic level of normalized tables.  

To better understand the definition for 1NF, it helps to know the difference between a domain, an attribute, and a column. A domain is the set of all possible values for a particular type of attribute, but may be used for more than one attribute. For example, the domain of people’s names is the underlying set of all possible names that could be used for either customer-name or salesperson-name in the database table. Each column in a relational table represents a single attribute, but in some cases more than one column may refer to different attributes from the same domain. When this occurs, the table is still in 1NF because the values in the table are still atomic. In fact, standard SQL assumes only atomic values and a relational table is by default in 1NF.

Related questions

+1 vote
1 answer 44 views
+1 vote
1 answer 85 views
+1 vote
1 answer 152 views
+1 vote
0 answers 35 views
+1 vote
1 answer 103 views
+1 vote
1 answer 87 views
asked Sep 28 in Others by anonymous
+1 vote
1 answer 77 views
asked Sep 28 in Others by anonymous
+1 vote
1 answer 27 views
+1 vote
1 answer 82 views
asked Sep 21 in Others by anonymous
+1 vote
1 answer 80 views
asked Sep 2 in Others by anonymous
+1 vote
1 answer 199 views
+1 vote
1 answer 114 views
+1 vote
1 answer 89 views
asked Sep 28 in Others by anonymous
+1 vote
1 answer 109 views
asked Sep 22 in Others by anonymous
+1 vote
1 answer 119 views
+1 vote
1 answer 72 views
+3 votes
1 answer 995 views
0 votes
1 answer 38 views
asked 3 days ago in Computational Tools by (user.guest)
0 votes
1 answer 30 views
asked 3 days ago in Computational Tools by (user.guest)
+1 vote
0 answers 32 views
0 votes
1 answer 62 views
asked Oct 25 in Others by (user.guest)
+1 vote
1 answer 106 views
asked Oct 11 in Others by anonymous
+2 votes
1 answer 68 views
+1 vote
1 answer 33 views
+1 vote
1 answer 30 views
+1 vote
1 answer 57 views
+1 vote
1 answer 175 views
+1 vote
1 answer 96 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...