Referring to the table as shown in Table1 Each field in a table must have a unique name State TWO (2) field names 4 Marks Indicate which field or fields that make up the primary key, which is the unique identifier State the primary key for the above table 2 Marks Each field has a data type This indicates the type of data that can be stored in the field Briefly explain the data types that will be used in this project (based on the above table) 4 Marks EmployeeID FirstName LastName 1 Davolio Nancy Andrew 2 3 Janet Fuller Levering Peacock 4 4 Margaret HireDate City 1 5 1992 12 00 00 AM Seattle 14 8 1992 12 00 00 AM Tacoma 1 4 1992 12 00 00 AM Kirkland 3 5 1993 12 00 00 AM Redmond 17 10 1993 12 00 00 AM London 17 10 1993 12 00 00 AM London 2 1 1994 12 00 00 AM London 5 3 1994 12 00 00 AM Seattle 15 11 1994 12 00 00 AM London 5 Steven Buchanan 6 Michael 7 Robert Suyama King Callahan 00 8 Laura 9 Anne Dodsworth

The Answer is in the image, click to view ...

Question: Referring to the table as shown in Table1 . Each field in a table must have a unique name. State TWO (2) field names. [4

Referring to the table as shown in Table1.

Referring to the table as shown in Table1 . Each

Each field in a table must have a unique name. State TWO (2) field names.

[4 Marks]

Indicate which field or fields that make up the primary key, which is the unique identifier. State the primary key for the above table.

[2 Marks]

Each field has a data type. This indicates the type of data that can be stored in the field. Briefly explain the data types that will be used in this project (based on the above table).

[4 Marks]

EmployeeID FirstName LastName 1 Davolio Nancy Andrew 2 3 Janet Fuller Levering Peacock 4 4 Margaret HireDate City 1/5/1992 12:00:00 AM Seattle 14/8/1992 12:00:00 AM Tacoma 1/4/1992 12:00:00 AM Kirkland 3/5/1993 12:00:00 AM Redmond 17/10/1993 12:00:00 AM London 17/10/1993 12:00:00 AM London 2/1/1994 12:00:00 AM London 5/3/1994 12:00:00 AM Seattle 15/11/1994 12:00:00 AM London 5 Steven Buchanan 6 Michael 7 Robert Suyama King Callahan 00 8 Laura 9 Anne Dodsworth

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

JavaScript (Simple) Framework Homework Overview: In this homework you will implement provider code (a function in an external JS file) that can produce a click sortable HTML table from any JSON...

ADM 1370 - Applications of Information Technology for Business - Winter 2022 - Assignment 3 Database Table Descriptions VOLUNTEERS Attribute Type Volunteer ID Number Volunteer_Last Name Short Text...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

Written in Java. Please help. Any information would be greatly appreciated. Even shelling of the code would be beneficial if you cannot understand the whole thing. Thank you!!!!!!!!!!!!!!!!!! Example...

Requirements 1. Using Access or a similar relational database, create the tables needed to set up a database for contributors, contributions, and animals. 2. What data field did you use for the...

Need assistance solving so I can check my answers for these 5 problems. Formulas (on a separate sheet) would be helpful. Thank you _x000D_ Accounting and Microsoft Excel_x0 -> data creation_x -> data...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

In 2021, Jon makes the following donations: a. $10,000 cash to his church b. $500 check to the Guayaquil Soup Kitchen, a charity based inEcuador c. 100 shares of stock with a fair market value of...

Using Exhibit 19.12 as a guide, prepare summary journal entries to record the following transactions and events a through h for a company in its first month of operations. a. Raw materials purchased...

According to the 2 0 0 2 Report to the Nation on Occupational Fraud and Abuse, what percentage of corporate revenues were lost in that year to fraud? Group of answer choices 2 % . 4 % . 6 % . 8 % .

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...