From the Department Table, List the department code, the department name and school code of all departments with a school code of "BUS"

From the course Table, List the Department Code and Corse Description of all corses that have 3 credits

From the Class Table, list all section numbers for course code "CIS-220"

From the Employee Table, List Last Name, First Name and Middle Initial of All Employee with a Job Code of "TECH"

From the Professor Table List all Professors with a Department Code of "CIS".  This the employee code and department code and degree of the professor

Additionally. create the following queries

List the meeting times of all Accounting Classes

List the Course Description and Credits for all CIS Courses

List the Department Code, Department Name and Phone Number of all departments

List the full name and Date of Birth of All Employees Hired Before 1980

List the Full Name and Phone Number of all students with Grade Point Averages less than 3.0

 

 

Metadata for Tiny College
Course
Attribute Name
CRS_Code
Dept_Code
CRS_Description
CRS_Credit Data Type
Text
Text
Text
Number Range
10
10
35
all Description
Course Code
Department Code
Description of the Department
Number of Credits for Course Department
Attribute Name
Dept_Code
Dept_Name
School_Code
Emp_Num
Dept_Address
Dept_Extension Data Type
Text
Text
Text
Number
Text
Text Range
10
30
8
All
20
4 Description
Department Code
Department Name
School Code
Employee Code of Department Head
Address of Department
Phone Extension of Department Employee
Attribute Name
Emp_Num
Emp_Lname
Emp_Fname
Emp_Initial
Emp_JobCode
Emp_HireDate
Emp_DOB Data Type
Integer
Text
Text
Text
Text
Date
Date Range
15
12
1
5
Valid Date
Valid Date Description
Employee Number
Last Name of Employee
First Name of Employee
Middle Initial of Employee
Job Title Code of Employee
Date Employee that was Hired
Employee’s Date of Birth Class
Attribute Name
Class_Code
CRS_Code
Class_Section
Class_Time
Class_Room
Prof_Num Data Type
Text
Text
Text
Text
Text
Integer Range
5
10
2
20
8
all Description
Class or Section Code
Course Code
Section Code
Meeting Times of Class
Room where class is held
Code of Professor Teaching the course Enroll
Attribute Name
Class_Code
Stu_Num
Enroll_Grade Data Type
Text
Integer
Text Range
5
All
2 Description
Class Code
Student Code
Grade obtained in Class Taken Professor
Attribute Name
Emp_Num
Dept_Code
Prof_Office
Prof_Extension
Prof_High_Degree Data Type
Integer
Text
Text
Text
Text Range
All
10
50
4
5 Description
Employee Number of Professor
Department Code
Office Number and Location
Phone Extension Number
Highest Degree Obtained by Professor Student
Attribute Name
Stu_Num
Stu _Lname
Stu _Fname
Stu _Initial
Stu _Class
Stu _GPA
Stu _DOB Data Type
Integer
Text
Text
Text
Text
Number
Date Range
All
15
15
1
2
All
Valid Date Description
Student ID Number
Student’s Last Name
Student’s First Name
Student’s Middle Initial
Good Question
Student’s Grade Point Average
Student’s Date of Birth Stu_Hours
Stu_Transfer
Stu_Phone
Prof_Num
Dept_Code Integer
Number
Text
Integer
Text All
All
4
All
18 Credits Earned by Student
Good Question
Students Phone Number
Student’s Advising Professor
Department Code or Students Major List the meeting times of all Accounting Classes
List the Course Description and Credits for all CIS Courses
List the Department Code, Department Name and Phone Number of all departments
List the full name and Date of Birth of All Employees Hired Before 1980
List the Full Name and Phone Number of all students with Grade Point Averages less than 3.0

• 1493689961-Metadata for Tiny College 1.pdf

ComputerScienceExpert

(11)

Status NEW Posted 02 May 2017 01:05 AM My Price 8.00

-----------

Attachments

file 1493689962-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer