3 votes 3 votes Databases databases er-diagram database-normalization + – ashish pal asked Nov 18, 2017 ashish pal 1.2k views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply vamp_vaibhav commented Nov 29, 2017 reply Follow Share Answer is 4?? 2 votes 2 votes BASANT KUMAR commented Oct 5, 2019 reply Follow Share 3 table is enough .it is asking about just 1NF for composite we can combine with other attribute to make it prime attribute. 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes I think we need 4 tables. 3 tables for 3 entities and one for multivalued attribute Ph_no in 1st entity. table 1: Code , Name, Addr . table 2: Code, Ph_no. table 3: Branch No, Code, Addr, Bank name table 4: Loan_no, amount, type, Branch No. pradeepdeepu answered Nov 18, 2017 edited Nov 18, 2017 by pradeepdeepu pradeepdeepu comment Share Follow See 1 comment See all 1 1 comment reply ashish pal commented Nov 18, 2017 i edited by ashish pal Nov 29, 2017 reply Follow Share @pradeepdeepu why can't we combine the table 3 and table 4 since the database need to satisfy just 1NF. 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes 4 table is required abhishekmehta4u answered Mar 24, 2018 abhishekmehta4u comment Share Follow See all 2 Comments See all 2 2 Comments reply srestha commented Mar 25, 2018 reply Follow Share for multivalued dependency how many table more required? 1 more table, right? 0 votes 0 votes Tuhin Dutta commented Mar 25, 2018 reply Follow Share 1 extra is required for satisfying 2NF and above but for 1NF we need just 3 tables. 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes I think we need 5 tables. 3 for 3 entities, 1 for multivalued attribute and another for the Loans relationship. souravsaha answered Dec 6, 2017 souravsaha comment Share Follow See 1 comment See all 1 1 comment reply Abbas commented Jan 14, 2018 reply Follow Share " another for the Loans relationship " ?? not able to understand this.... 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes 3 tables are required since they have asked for 1NF. when given ER diagram is converted into a table, then every record contains atomic values. i.e. If a person has 2 phone & 2 office then that person will have 4 records, but then every record contains atomic values only. Thus relation is always in 1NF. For 2NF and above we need 4 tables. Read here: https://gateoverflow.in/29974/minimum-number-of-relation-for-given-er-diagram Another good read: https://www.tutorialcup.com/dbms/er-model-into-tables.htm Tuhin Dutta answered Mar 25, 2018 Tuhin Dutta comment Share Follow See all 0 reply Please log in or register to add a comment.