Which of the followings are entities? Why? (3 points)

Address

Employee

Sales Order

Revenue

Course

Enroll

Course Section

Customer

Unit Price

Unit Cost

Name

Part

The four components of an Enterprise system are people, database, processes, and information flow among business functions. Which of these components is the most essential one? Why? (1 point)

What is the operational database? What are the master and transaction databases? (1 point)

What is a relationship type between a patient and physician? State the assumption you made for your answer. (1 point)

What are primary (entity identifier), candidate, and foreign keys? (1 point)

Explain how a relationship cardinality constraint between two entities is identified. (1 point)

What is an attribute, a composite attribute, a derived attribute, and a multivalued attribute? (1 point)

Explain how M:N relationship between two entities, say A and B, is transformed into two 1:M relationships. (1 point)