Question: consider a designer, and you have the relations below, which is questions 1 and 2 . Stady relation. Stally answer the questions 1 and 2

consider a designer, and you have the relations below, which is questions 1 and 2. Stady relation. Stally answer the questions 1 and 2.(2marks)
\table[[empName,role,projName],[Snith,designer,Nile],[Snith,designer,Anazon],[Snith,progranner Anazon,],[Jones,designer,Mile],[Jones,designer,Anazon]]
Table 3
Table 3
1- There are four guidelines that are used as measures of the quality of relation schema design. Which guideline is violated in the relation above?
2- Examine the relation if it is in INF or not? Justify your answer and normalize it if necessary.
\table[[STUD_NO,STUD_NAME,STUD_PHONE,STUD_STATE,STUD_COUNTRY],[1,RAM,\table[[9716271721,],[9871717178]],HARYANA,NDA],[2,RAM,9898297281,PUNAB,NDA],[3,SURESH,,PUNLAB,NDA]]
 consider a designer, and you have the relations below, which is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!