Reference no: EM131928793
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.
|
What is the equivalent annual cost for the mower
: What is the equivalent annual cost for the mower? What is the NPV of buying tractor A?
|
|
Expected rate of return on market portfolio-on each stock
: If each scenario is equally likely, find the expected rate of return on the market portfolio and on each stock.
|
|
Weigh the benefits and associated costs of security
: Generally, the greater the security, the greater the cost. Discuss how one should weigh the benefits and associated costs of security.
|
|
Balanced scorecard and communication plan - amazon
: Develop the strategic objectives for your new division of the existing business in a balanced scorecard format in the context of key trends, assumptions
|
|
Create table resourcetypes
: Create table "ResourceTypes" with the following fields (as always: keep the field names exactly as specified below and the data types
|
|
How much will you have at the end of two years
: Let's say you find a super-secret-awesome bank account that offers 1000% interest. If you put your $2 into this account, how much will you have at the end.
|
|
What is the cash flow from assets for given year
: Quarles Industries had the following operating results for 2015: sales = $30,540; cost of goods sold = $19,910; depreciation expense = $5,380;
|
|
Explain what makes a good business decision
: What are the six steps managers should take to make the best decisions?What are some of the advantages and disadvantages of group decision making?
|
|
Calculate the bandwidth-delay product
: Suppose two hosts, A and B, are separated by 40,000 kilometers and are connected by a direct link of R= 4Mbps.
|