Databases | SQL | Oracle | MS Access Answers

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

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 8 yrs or more.

Make a parameter query thats allows the user to choose which birth month to display,. So when the use is prompted for birth month, they might type 3, for March, and only the records which have a Date of Birth (dd/mm/yyyy) in March, will display

Write a SELECT statement that changes the phrase Today is Monday to Today is Tuesday

how does mc access works

Database Systems - (Query) I have duplicate invoices and I need to combine the customer balances. How do I write the equation?

Entities are