First normal form (1NF) :As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values.Example: Suppose a company wants to store the names and contact details of its employees. It creates a table that looks like this:This table is not in 1NF as the rule says “each attribute of a table must have atomic (single) values”, the emp_mobile values for employees Jon & Lester violates that rule.

Question

First normal form (1NF) :As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values.Example: Suppose a company wants to store the names and contact details of its employees. It creates a table that looks like this:This table is not in 1NF as the rule says “each attribute of a table must have atomic (single) values”, the emp_mobile values for employees Jon & Lester violates that rule.

Lalitesh sharma · Accepted Answer

First normal form (1NF) :As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values.Example: Suppose a company wants to store the names and contact details of its employees. It creates a table that looks like this:This table is not in 1NF as the rule says “each attribute of a table must have atomic (single) values”, the emp_mobile values for employees Jon & Lester violates that rule.

What will be the output of the following program?abstract class userInfo{ public $firsname; public $lastname; public function...

SQL was first developed:

When did HBase was first released?

The ratio of the first and second-class fares between the two stations is 6 : 4 and the number of passengers traveling by fir...

Identify the FIFO (First In First Out) structure among the following :

Can the element <First> be replaced with <first>?

Can the element <First> be replaced with <first>

Which scheduling algorithm allocates the CPU first to the process that requests the CPU first?

Who has become the first-ever batsman to score twin hundreds in his first Test as opener?

Who was the first Chief Guest on the very first Republic Day parade of India in 1950?

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

Study24x7

Henry Harvin

CBSE Study Materials

Digital Marketing - Learn SEO, PPC, SMO,...

Defence

UPSC & State PSC

SSC Preparation Strategies & Study Mater...

Banking/IRDA

DEFENCE EXAM PREPARATION

Get the App

Daily NEWS Analysis | The Hindu Analysis 31st January | UPSC...

The Top Ten Steps to Plan Any Event

Crack the SSC CGL Exam in your first attempt! | Things You S...

Role of Blockchain in Mobile App Development: A Comprehensiv...

UPSC Prelims Exam Overview

Minification

IBPS Recruitment Guide for various Academic Positions

Best Social Learning Platform In India | Study24x7

UPSC 2020 Exam - NEWS Analysis 3rd January

SSC CGL 2020 Exam - Reasoning 3