Databases | SQL | Oracle | MS Access Answers

A supertype entity Vehicle in the Division of Motor Vehicles' database has the following attributes: VIN, Make, Model, Color, VehicleType.
VIN is the identifier and joins the Vehicle entity to these entities: Car, Truck, Bus and Bike
Because Car, Truck, Bus and Bike inherent the attributes mentioned above from Vehicle, they are called ___________________.

Supertype
Subtype
Strong
Associative

At company X, an Employee may have none or many Dependents. A Dependent may only be in a single Employee's insurance. What is the cardinality of the relationship between Employee and Dependent?

Unary
One-to-Many
One-to-One
Many-to-Many

In an entity, an identifier is an attribute that uniquely identifies an instance of the entity. If ID is an integer attribute and is the identifier of entity X, how many times can ID 10 appear?

Once
Up to 10 times only
Never because it is the identifier
As many times as needed because it is the identifier

A Unary relationship involves how many entities?

1
2
0 or more
3

What is the data model that contains the business requirements for the database?

The Logical
The Enterprise
The Conceptual
The Physical

Which data model is used to build the database?

The Enterprise
The Conceptual
The Physical
The Logical

Select all the objects contained in a Data Model (you must choose all the valid options)

Relationships
Attributes
Entities
Diagrams

1. When following the methodology taught in class, what is the first model the Data Modeler develops?

Enterprise Data Model
Physical Model
Conceptual Model
Logical Model

The field Tonnage is used in a shipping line database to store the cargo capacity (in Tons) of ships operated by the line. Example of valid Tonnage values are: 13908, 23675, 187890, 27510 Select a valid metadata for this field from the choices below

String
Date
numeric without decimal point
numeric float with one decimal point

Make a Update Query that will add the phrase "Free Champagne for this Preferred Guest" to the Comments field, but only if the guest stays for days or more.

CHECK-IN DATE CHECK-OUT DATE
2/28/2018 3/28/2018
3/27/2018 3/31/2018
3/5/2018 3/17/2018
3/1/2018 3/3/2018
3/11/2018 3/15/2018
3/6/2018 3/14/2018
4/8/2018 4/19/2018
3/5/2018 3/10/2018
3/11/2018 3/17/2018
3/22/2018 3/24/2018
3/18/2018 3/24/2018
2/28/2018 3/3/2018
3/18/2018 3/24/2018
3/19/2018 3/30/2018
3/18/2018 3/23/2018
3/1/2018 3/3/2018
3/4/2018 3/9/2018