+1 vote
68 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 39 views
+1 vote
1 answer 80 views
+1 vote
1 answer 143 views
+1 vote
0 answers 29 views
+1 vote
1 answer 98 views
+1 vote
1 answer 77 views
asked Sep 28 in Others by anonymous
+1 vote
1 answer 70 views
asked Sep 28 in Others by anonymous
+1 vote
1 answer 25 views
+1 vote
1 answer 77 views
asked Sep 21 in Others by anonymous
+1 vote
1 answer 75 views
asked Sep 2 in Others by anonymous
+1 vote
1 answer 190 views
+1 vote
1 answer 109 views
+1 vote
1 answer 86 views
asked Sep 28 in Others by anonymous
+1 vote
1 answer 105 views
asked Sep 22 in Others by anonymous
+1 vote
1 answer 112 views
+1 vote
1 answer 67 views
+3 votes
1 answer 984 views
0 votes
1 answer 18 views
asked 14 hours ago in Computational Tools by (user.guest)
0 votes
1 answer 14 views
asked 14 hours ago in Computational Tools by (user.guest)
+1 vote
0 answers 28 views
0 votes
1 answer 57 views
asked Oct 25 in Others by (user.guest)
+1 vote
1 answer 26 views
+1 vote
1 answer 100 views
asked Oct 11 in Others by anonymous
+2 votes
1 answer 62 views
+1 vote
1 answer 28 views
+1 vote
1 answer 52 views
+1 vote
1 answer 174 views
+1 vote
1 answer 90 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...