Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
You group has been hired by TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling.
COURSE table contains following information:
Note: Primary Key (PK) is COURSE ID
Identify FK, if any
TRAINEE table contains following information:
Note: PK is (Trainee ID, Course_ID)
Training session signed for is the same as Course ID in COURSE table
Following sample data is available:
COURSE Sample data
Course ID
Price ($)
Instructor Name
Instructor Address
S111
2850
Harry
UB
S121
3200
Polly
S145
1200
Smith
Loyola
H111
500
Morton
JHU
H123
2200
David
TRAINEE sample data
Trainee ID
Course_ID
Trainee Name
Date of training
A101
Sam Paper
10/02/2009
Sam paper
10/03/2009
A110
Mary Poppins
11/01/2009
B112
Alex Johnson
11/02/2009
11/06/2009
B222
John Watt
10/01/2009
10/05/2009
C111
Jong Chu
F456
Jerry Long
11/08/2009
F555
Willy Polk
X123
Shirley Dent
PART A:
Table 1 (identify PK and FK relationships)
Table Name
COURSE
TRAINING
Primary Key (PK)
Foreign Key (FK)
Submit this table as Part A (section 2) requirement to be submitted see below
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 Polk9. Give the names of instructors teaching on November 6th
How many physical thing?
Describe how you can simplify Operations. To simplify operation, one should use inheritance, where possible to use, to reduce the quantity of distinct operations. Introduce new
What is a disjoint less constraint? Ans: It needs that an entity belongs to no much more than one level entity set. Disjoint less constraint needs that an entity belongs to
Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont
what is lossless & dependency preserving decomposition ?
XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v
Explain the disadvantages of creating a temporary table? If you have already created a temporary table with a shown name and attempting to create a second one with that nam
HOW MANY TYPES OF VIEWS
What are the kinds of Strings? -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt
NEED ER DIAGRAM WITH MINIMUM ENTITY AND RELATIONSHIP of Hospital Management System
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd