Question

Learning Sql sever we need to understand by reading and picking the best options to these questions
A. In the info below, LastName is considered which of the following? pick one---- an attribute, a tuple, a view

Employee_id .........LastName..........Job ...........Email
1........................... wilson .................teacher........... [email protected]
2............................smith ......... ......sub
3.............................Anderson .... admin

B. Consider a database used to track classes at the college. Currently, the database design includes three tables: BiologyClasses, PhysicsClasses, and PhilosophyClasses You disagree with this design approach and, using abstraction, you determine that these three tables could be combined into one table called ___________.(note: not a CPK...that was wrong) (Note to help for below questions -Diagram with Genre and Film tables. Genre is on the one-side of the relationship, and Film is on the Many side of the relationship. ) (story used to guess the correct item below)

C Three bears lodge rents out their Mt. Rainier area cabins to guests and wants to track these rentals. They currently have three cabins: Little Bear, the Dancing Bear, and Coho Cabin, but are planning to acquire more cabins in the future.

1 Coho Cabin is most likely... a value, a table or irrelevant (pick the best one)

2 Future is most likely.. . a fielld, a value, irrelevant (pick one)

3 Guests is most likely.... a field, a table or irrelevant (Pick one)

Answer 1

A. An attribute

Reason: Lastname is attribute of the table as it is one of the details of employee.

B. Sciences and Humanities Classes (Kind of)

Reason: Sciences and Humanities have Biology, Physics and Philosophy branches and it follows one to many relationship.

C.

1. Value

Reason: Coho Cabin is one of the cabins that can be rented where cabin name can be treated as attribute.

2. Irrelevant

Reason: Future makes no sense in relational database in the present.

3. Table

Reason: Guest details must be stored in table and can be associated with the rental cabin in attribute associated with the table.