ER Model

ER-model, Relational model (relational algebra, tuple calculus), Database design (integrity constraints, normal forms), Query languages (SQL), File structures (sequential files, indexing, B and B+ trees), Transactions and concurrency control.

ER Model

Postby BabitaSan » Wed Jan 22, 2014 3:59 pm

Relations produced by an ER model are in which normal form?

a. 1NF
b. 2NF
c. 3NF
d. BCNF

In some books the answer is 3NF while in some, its answer is 1NF.

Could anybody please tell me it's answer with explanation?

Thanks
BabitaSan
 
Posts: 2
Joined: Wed Jan 22, 2014 3:54 pm
My College/Company:: DCE
Roll Number: 0

Re: ER Model

Postby sameer2009 » Thu Jan 23, 2014 3:33 pm

Normally, a ER Model which is converted to relational schema has 1NF.
Else it depends upon how ER Modelling has been done.
Check this out!!! Free Android App for Computer Science and Engineering Exam.
Download .apk file @ tinyurl.com/csexamapp
See How To Use @ tinyurl.com/csexamapplication
sameer2009
Gatementor Guru
Gatementor Guru
 
Posts: 1433
Joined: Tue Sep 09, 2008 5:29 pm
My College/Company:: lt
Roll Number: 99999

Re: ER Model

Postby Chandan1990 » Sat Apr 05, 2014 10:53 am

asdxasd
Arise Awake, Doesn't Stop till the Goal Achieved !
Chandan1990
Gatementor Newbie
Gatementor Newbie
 
Posts: 188
Joined: Wed Nov 03, 2010 2:02 pm
My College/Company:: WCE Sangli
Roll Number: 99999999
City: Sangli


Return to Databases

Who is online

Users browsing this forum: No registered users and 3 guests
cron