Develop the tables in access database systems

Assignment Help Management Information Sys
Reference no: EM132153788

Training Database Assignment -

You group has been hired by TrainingrUs to keeps track of training revenues. TrainingrUS wants you to keep scheduling.

COURSE table contains following information:

  • Course ID (PK)
  • Price
  • Instructor Name
  • Instructor Address

Note: Primary Key (PK) is COURSE ID.

TRAINEE table contains following information:

  • Trainee ID (PK)
  • Course_ID (PK)
  • Trainee name
  • Date of training

Note: PK is (Trainee ID, Course_ID)

FK is Course ID

Training session signed for is the same as Course ID in COURSE table.

PART A -

  • Develop the tables in ACCESS database Systems.
  • Identify PK and FK of each table (can do in WORD).

Table Name

COURSE

TRAINING

Primary Key (PK)



Foreign Key (FK)



Submit this table in Part A (section d) to be submitted see below

Show the relationship (1:1 or 1:m or m:n) between the following:

COURSE and TRAINEE in ACCESS and include a print screen (see under submission PART A, section c)

Justify why it is 1:1 or 1:m or m:n

PART B: Develop the following queries in ACCESS and run (execute) them

1. List the course ID and its cost, format the output appropriately.

2. Give the trainee name and the number of classes each trainee is taking.

3. How many trainees are taking classes on November 6th? (Give a count)

4. Give the training sessions and their dates (make sure there is no repetition of session and corresponding date).

5. How many students are registered per training section?

6. How many courses are there?

7. How many classes John Watt is taking?

8. Give the total amount paid by Willy Polk

9. Give the names of instructors teaching on November 6th

10. Create an Enrollment report of Dates and Overall total number of students taking classes on those dates, i.e., 10/02/2009; 10/03/2009.

Create a REVENUE report to provide date, session IDs, number of students and total revenue for TrainingrUs. Format the output appropriately.

Part A:

a. Tables in ACCESS (see section b of part B below)

b. Table contents of each table in ACCESS (print screen shot of contents)

c. Relationships in ACCESS (print screen shot of contents)

d. PK and FK table

Part B:

a. Build Queries in ACCESS and run them (Print screen shots of queries and their output in ACCESS)

b. actual ACCESS database with queries (save the database and submit the access database file with .mdb extension in 2003 or accdb extension in 2007). This will also satisfy section "a" of PART A since your tables will be there on the same file.

Attachment:- Assignment File.rar

Reference no: EM132153788

Questions Cloud

Discussing servant leadership : In my current class we are discussing Servant Leadership and what it mean. I have to locate two articles, what site do you suggest?
Determining the order quantity-safety stock for writing desk : Please help Greg out by determining the order quantity, reorder point and the safety stock for writing desks.
How could you use operant conditioning to change behavior : Psychologists like B. F. Skinner have studied how we can use operant conditioning to change the behavior of people and animals. Drawing on your personal.
Role of leaders plays in this area : Identify social connection an cohesion(groups and teams). Again asking to take to the role of leaders plays in this area.
Develop the tables in access database systems : Training Database Assignment - Develop the tables in ACCESS database Systems. Identify PK and FK of each table (can do in WORD)
How long will it take to perform the eighth repetition : If a company knows that its new employees have a seventy-five percent learning rate, How long will it take to perform the eighth repetition?
Cultural intelligence the competitive edge for leaders : Julie Middleton entitled "cultural Intelligence the competitive edge for leaders". Need to understand about CI.
Develop strategic thinking on principles of vision : How to develop strategic thinking on principles of vision, values and mission for a business.
What is the farmers breakeven point in dollars : What is the farmer's breakeven point in units (pounds) under the old system? What is the farmer's breakeven point in dollars? Show all math.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

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!

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