Please answer all questions ackboard ncateduwebappsassessmentnakenakejsp?course

Question

Please answer all questions ackboard ncateduwebappsassessmentnakenakejsp?course assessment ide 129194 18course de us219m.18content-id .2719476 18question nu Fowoe Completion This can be saved and mesumed Moving to another weston save this response. Question 1 location name Departments cost COSt Parts Contracts Projects Coevert the above ER diagram to relations in the normal manner, and then identify w ofthe following isnot a relation schema o a Projects(name, cost) Ob Departments (name, location) O Contracts(name) akto me

Explanation / Answer

1 - c [Contracts(name)] it should be Contracts(name,name,name)

2 - [empID,deptName] (Superkey is a combination of columns that uniquely identifies any row within a relational database)

4 - 8 (The number of attributes constituting a heading is called the degree, which term also applies to tuples and relations. The term n-tuple refers to a tuple of degree n (n 0))

6 - a (rest all contains "semester" which is an attibute of "Teaches" relationship)

7 - a ("address" is a composite attribute)

8 - b (rest all are true)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.