View the step-by-step solution to:

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

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.


Submit your database file that shows all tables, records, and queries as well as the screen shot document from Question 5 to me via the messaging feature in the classroom.

Top Answer

Answer 1: CREATE TABLE ResourcesTypeos (   TypeId int NOT NULL,   Type text(30),   Comment text(100),   Status... View the full answer

Answer 1.PNG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online