Using the database provided(Access Database is in Blackboard under “Lessons/Week
ID: 3704459 • Letter: U
Question
Using the database provided(Access Database is in Blackboard under “Lessons/Week #3”). Write and Execute SELECT statements to get the following information(Please print out and turn in all the SQL code that you wrote to get the answers to these questions or problems, you do not need to turn in the answers, just SQL code).
See handout in blackboard, under “Week #3”, for help in using SQL in MS Access.
Problems:
Courses Table :
1. List of all courses with CourseNo, Name and CreditHours.
2. List of courses, all columns, with only 3 credit hours.
3. List of courses, name and credit hours only, with credit hours > 3.
Instructors Table :
4. List of Instructors, only fname and lname, from Georgia.
5. List of all instructors not from Georgia.
6. List of instructors, just name and office and email from Florida.
7. List all instructors, id, lname and email with headings “ID#”, “Name “and “E-Mail Address”.
Sections Table :
8. List of Sections with CRN, timedays for instructor 3.
9. Does roomNo F1149 have any scheduling conflicts?
10. Does instructor 6 have any scheduling conflicts?
Students Table :
11. List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to 2.99).
12. List of students from Georgia or Colorado.
13. Which students have a B avg from Ga(3.0 to 3.99)?
14. Give me a list of all the Larry’s that are students (just give first and last names).
Table Tools Access Sign in File Home Create External Dato Database Tools Fields abe Tell me what you want to do Custom Custom Group Unassigned Objects Courses Instructors sections students CourselD CourseName Description CreditHours Click to Add- r Concepts Intro to Computers Hardware Maintainence Explore how an Operating System works Learning about SQL Intro to Programming Networking Fundamentals Develop Web-pages using HTML Intro to C# Programming Advanced C# Programming Intro to Java Intermediate Java Topics Object Oriented Analysis and Design Capstone Project Class Using Java to build Web Applications IST 1001 CIST 1122 CIST 1130 CIST 1220 CIST 1305 CIST Hardware Maintainence Course Operating Systems SQL Programming Program Design and Development Networking Fundamentals Web Development I Cf Programming I C# ProgrammingI Java Programming I Java Programming lI Analysis and Design - 1401 10 CIST 15 CIST 2341 CIST 2342 CI ST 2371 CIST 2372 CIST 2921 CIST 2931Systems Project ST 3273 Java Programming II Record: l-M 1 of 14 ??1 K: No Filter | Search Datasheet View ? O Type here to search 1:36 PM 2/1/2018Explanation / Answer
SELECT CourseNo, Name, CreditHours FROM Courses; SELECT * FROM Courses WHERE CreditHours == 3; SELECT CourseName, CreditHours FROM Courses WHERE CreditHours > 3; SELECT FirstName, LastName FROM Instructors WHERE City == 'Georgia'; SELECT * FROM Instructors WHERE NOT (City == 'Georgia'); SELECT FirstName, LastName, Office, EMail FROM Instructors WHERE City == 'Florida'; SELECT 'ID#' AS ID, 'Name' AS LastName, 'E-Mail Address' AS EMail FROM Instructors; SELECT CRN, TimeDays FROM Sections WHERE Instructor == 3; s d SELECT FirstName, LastName, GPA FROM Students WHERE (GPA >= 2.0 AND GPA = 3.0 AND GPARelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.