You need to keep track of information about software and programmers. Each software application program has a unique ID (SID) and each programmer has a unique ID (PID). 

Draw E-R diagrams for each of the three scenarios below.  (Use Pen and Paper to draw an ERD instead of LuchidChart or Visio)

 

Assume that each scenario is separate and stand-alone.  Make sure you show the ids and cardinalities, associative entities, and disjoint, and overlap joints.

 

            a. A program must have a single programmer, but a programmer may write multiple programs. 

 

 

            b. A program must be associated with at least one or several programmers, but each programmer works on only one program.

 

 

            c. A program may be written by several programmers and each programmer might work on several programs.

 

 

After drawing ER diagrams, construct normalized relations of the above 3 scenarios (a, b, and c).  Use the proper form and show your IDs. Additional attributes are not necessary.

            a.

 

            b.

 

            c.

 

 

Q4. Use the following diagram. Using the transformation rules, how many relations will it take to transform this hypothetical ERD?

If you apply the domain concept to each of the multivalued attributes then how many total relations will be required?

 

MV stands for multi-valued attributes, TD stands for transitive dependency and 2NF stands for a second normal form violation.

  

MY 7+ 2NF MV TD MV