User Account

All Pages

Foreign key referencing the resourcetypes

Assignment Help Basic Computer Science
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.

Reference no: EM131934499

Questions Cloud

Convert the table from unnormalised form : Convert the table from Unnormalised Form (UNF) to First Normal Form (1NF)
Explain how you would work with that population : Explain how you would work with that population with cultural competency. Specifically address substance abuse.
Advantages and disadvantages of type of testing : Discuss the advantages and disadvantages of each type of testing. When is each type of testing appropriate?
Describe bene?ts and drawbacks of a source-driven : Describe bene?ts and drawbacks of a source-driven architecture for gathering of data at a data warehouse, as compared to a destination-driven architecture
Foreign key referencing the resourcetypes : Create table "ResourceTypes" with the following fields (as always: keep the field names exactly as specified below and the data types
What was the authors primary argument : What was the author's primary argument? Describe in detail 1 example used by the author that most persuasively demonstrate their argument.
Benefits and associated costs of security : Discuss how one should weigh the benefits and associated costs of security.
Calculate the bandwidth-delay product : a. Calculate the bandwidth-delay product, R? dprop. b. How long does it take to send the file, assuming it is sent continuously?
Create the nano server : You are ready to create the Nano Server. You need to deploy the DNS server role on one server and the web services on two other Nano Servers.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Virtually all of municipal waste streams

Does the technology exist to reuse virtually all of municipal waste streams and make a profit? Might we ever mine out old landfills as an economic resource?

  Create a name class of three string objects

Provide methods and operators for reading and writing Persons and for allowing the retrieval and changing of components of a Person (Name and Address)

  Provincial manager for a financial services firm

As the Provincial Manager for a financial services firm, you are well regarded within your company and especially by many of the 82 employees

  Online course delivery system

Imagine that you are on a team that has been tasked with creating an online course delivery system. One of your coworkers wants to model the entire course in UML. Another coworker disagrees with the use of UML and would rather use pseudocode exclu..

  Discuss why concurrency control is needed

Discuss why concurrency control is needed

  System of equations using elimination or matrices

1. A company the manufactures aquariums has a fixed cost of  $118,000. It cost $140 to produce each aquarium. The selling price is $360 per aquarium. How many aquariums doe the business need to sell to break even?

  Analyze the effects on the equlibrium quantity

Analyze the effects on the equlibrium quantity, producer price Pn, and consumer price Pg of a $1 per unit tax on producers. What is the tax revenue?

  Explaining the most common security threats

Create a 10-slide basic or interactive presentation explaining the most common security threats, modern threats to current Client and Network Operating Systems, Encryption, Authentication, and Hashing. Include the narrator notes as a separate atta..

  How many different license plates are possible

License plates If a state wants each of its license plates to contain any 7 digits, how many different license plates are possible?

  Representations of sign and magnitude

1 Give the data representation of each of the following integers assuming 16 bits and each of the representations of sign and magnitude, one's complement, and two's complement. The answers must be expressed in hexadecimal. a. 5159c. -11111

  List the basic concepts of modern quality control

List the basic concepts taught in safety, health, and environment courses.

  Diploma mills on legitimate educational institutions

1) What is the impact of diploma mills on legitimate educational institutions? How does one check the credentials of learning institutions to verify legitimacy? What should one look for when selecting an institution of higher learning?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd