Reference no: EM131934499

Question 1: Create table "ResourceTypes" with the following fields (as always: keep the field names exactly as specified below and the data types, sizes and ranges exactly as specified. All fields required unless specified):

TypeId - autonumber unique id/primary key

Type - text(30) - examples could be Book, CD, DVD, Tape, VHS, eBook, Paper, Article, Movie, 35mm, etc...

Comment - Text(100)

Status - Active or Inactive

Question 2: Create table "Resources" with the following fields (as always: keep the field names exactly as specified below and the data types, sizes and ranges exactly as specified. All fields required unless specified):

ResourceId - autonumber unique id/primary key

TypeId - foreign key referencing the ResourceTypes table from Question 1

Resource - text(50)

Author - text(50)

Title - text(100)

PublicationReleaseDate - date

Quantity - integer number between 0 & 1,000,000

Comment - Text(100)

Status - Active or Inactive

Question 3: Create 5 records in each of the tables ResourceTypes and Resources. All values must be meaningful, compliant with the data types, data sizes, data values, and data bounds.

Values for the TypeId in the Resources table must reference the TypeId values for the foreign key TypeId in the ResourceTypes table.

Question 4: Create query named ResourcesQry which displays all resources as specified below:

Resource, Author, Title, PublicationReleaseDate, Type, Quantity

Question 5: Run or Execute the query ResourcesQry and take a screen shot of the results. Paste the screen shot into a Word document (or save it as a JPG or PDF).

Hint: Your answer should be a result-set table that displays the values of each of the fields for Resource, Author, Title, PublicationReleaseDate, Type, Quantity fields from the query.