Pre-Assessment Studying for OA
San Francisco, CA 94110, USA
How many attributes are gift inside the address fragment? - ANS-four.
Each entity is considered an characteristic.
-San Francisco
-CA
-94110
-USA
The Member table will have the following columns:
ID
FirstName
MiddleInitial
LastName
DateOfBirth
AnnualPledge
Write a SQL declaration to create the Member desk - ANS-CREATE TABLE Member (
ID INT UNSIGNED,
FirstName VARCHAR(one hundred),
MiddleInitial VARCHAR(1),
LastName VARCHAR(one hundred),
DateOfBirth DATE,
AnnualPledge DECIMAL(8, 2) UNSIGNED
);
The Package table has the following columns:
Weight
Description
LastChangedDate
TrackingNumber
Which column need to be designated the number one key for the Package desk? -
ANS-TrackingNumber.
This is the only option as a way to continually have to be UNIQUE.
The Rating table has the subsequent columns:
San Francisco, CA 94110, USA
How many attributes are gift inside the address fragment? - ANS-four.
Each entity is considered an characteristic.
-San Francisco
-CA
-94110
-USA
The Member table will have the following columns:
ID
FirstName
MiddleInitial
LastName
DateOfBirth
AnnualPledge
Write a SQL declaration to create the Member desk - ANS-CREATE TABLE Member (
ID INT UNSIGNED,
FirstName VARCHAR(one hundred),
MiddleInitial VARCHAR(1),
LastName VARCHAR(one hundred),
DateOfBirth DATE,
AnnualPledge DECIMAL(8, 2) UNSIGNED
);
The Package table has the following columns:
Weight
Description
LastChangedDate
TrackingNumber
Which column need to be designated the number one key for the Package desk? -
ANS-TrackingNumber.
This is the only option as a way to continually have to be UNIQUE.
The Rating table has the subsequent columns:
