1 votes 1 votes 1. How many minimum tables required which satisfy 1NF. 2. How many minimum tables required which satisfy BCNF. 3. How many minimum tables required which satisfy 4NF. Databases er-diagram model databases + – Shubhanshu asked Apr 2, 2017 retagged Jun 4, 2017 by Arjun Shubhanshu 1.9k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
5 votes 5 votes Minimum tables required which satisfy 1NF ==== 4 ( because of multivalued attributes ) Minimum tables required which satisfy BCNF ===== 4 (beacause each attribute is primary key ) Shubham Pandey 2 answered Apr 3, 2017 Shubham Pandey 2 comment Share Follow See all 9 Comments See all 9 9 Comments reply Show 6 previous comments joshi_nitish commented Nov 10, 2017 reply Follow Share @aekhn for some EID, it might be case that it has no phone no., in that case phone no. = NULL, but prime attributes should never be NULL according to entitiy intigrity constraint. so EID PolicyNo. PhNo. Email can not be primary key.. for 3 NF, 4 tables are required, one for orginal entitiy and 3 each for multivalued attribute. 2 votes 2 votes srestha commented Nov 10, 2017 reply Follow Share @ joshi_nitish we use multivalued attribute for 4 NF not for 3 NF rt? 0 votes 0 votes aehkn commented Nov 11, 2017 reply Follow Share In R(Eid,Ph.No) Ph.No still can be null so EIC is violated here too so will this Relation hold? 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes For 1NF We can make a single table by making Eid, policyNumber, email, and phone number a single candidate key. Garima Srivastava answered May 16, 2023 Garima Srivastava comment Share Follow See all 0 reply Please log in or register to add a comment.