Question

Which of the statements below best describes the following ER Diagram:

Question options:

	A professor may teach one or more classes but a student must take one or more classes. A class must be taught by one professor but a class may or may not have students.
	A professor must teach one or more classes and a class must be taught by one professor. A student may take one or more classes but a class must have one or more students.
	A professor may teach one or more classes and a student may take one or more classes. A class must be taught by one professor and a class must have at least one student.
	A professor is required to teach at least one class and students must take at least one class.

Question

Question options:

Hometown Plays sells tickets to performances at their local community theater. A ticket has a transaction id [Tid], the date and time of the performance as well as a seatNumber. Many tickets are sold for each performance.

Performances are identified by a unique performance number [Pnum], the title and the genre. A listing of actors for a performance is also retained. Actors are known by their Screen Actors Guild ID (SAGid) and name. Actors may perform in many different performances and performance may have many different actors.

Below is an E-R diagram for a database for Hometown Plays. Provide appropriate names for entities E1,E2, E3, identifiers I1, I2, I3, missing attributes, and relationship cardinality RC1, RC2.

E1

E2

E3

I1

I2

I3

A1

A2

A3

A4

RC1

RC2

Question

A continent is made up of countries but some countries span more than one continent. A country is made up of states or provinces but provinces cannot span more than one country. Map the ER diagram below to a set of tables. Be sure to use the proper text format for tables TABLENAME(primaryKeyAttribute[s], attribute1,attribute2, foreignKey[s]IfNeeded)

Question options:

Question

Normalize the table in the image to 3NF

Functional Dependencies:

Dept#, Cust# -> DeptName, Location, MgrID, MgrName, CustName, ComDate, Complaint

Dept# -> DeptName, Location,MgrID

MgrID -> MgrName

Cust# -> CustName

STUDENT PK STUD ID STUD FNAME STUD LNAME STUD STREET STUD CITY STUD ZIP CLASS PRTCLASSD ! CLASS NAME PROFESSOR PK I PROF-ID teaches PROF LNAME PROF FNAME PROF ID CLASS ID COURSE ID E1 A1 Date A2 RC1 E2 13 12 RC2 A4 Genre CONTINENT Name Area COUNTRY CountryCode Name Population Currency STATE/PROVINCE Name Capital City Normalize this Table into 3NF ustNameComDate Complaint 11232 Soap Division Cincinnati Mary Samuel S11 11314 Sundries New York Joe Brown G12 P10784 John Smith 1/12/1998 Incorrect Price YOU DO NOT NEED TO COPY THE DATA. Just identify the tables)