Final Assessment For Month 1

What should the primary key be according to the datasets

• Order ID

• Customer ID

• Row ID

• Ship Date

What can you liken the datasets to:

• A DBMS containing different databases

• A database containing different Tables

• A table containing different records

• A file containing different columns

How many records are in the original datasets?

(a)  

How many fields are in the dataset

(a)  

What is the datatype in Sales, Discount, Profit?

(a)  

What is the datatype in Quantity?

(a)  

What is the datatype in Product Name

(a)  

What was the file format/extension used?

• .CSV

• .XLSX

• .TSV

• .TXT

What type of data was presented to you?

• Structured

• Unstructured

• Semi-Structured

• Table

Primary keys can be more than one in a table

• True

• False