Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Q1. For the given relations:

Student(Name,student_number,class,major)
Course(course_name, course_number, credit_hour, department)
Section(section_identifier,course_number,semester,year,instructer)
Grade report(student_number, section_identifier, grade)
Prerequisite(course_number, Prerequisite_number)

Specify the given queries in SQL:

a) Retrieve the names of all the senior students majoring in 'COSC' (that is, computer science).

b) Retrieve the names of all the courses taught through professor King in 85 and 86.

c) For each part taught through professor King, retrieve the course number, semester, year and number of students who took the part.

d) Retrieve the name and transcript of each senior student (Class = 5) majoring in COSC. Transcript comprises course name, course number, credit hours, semester, year and grade for each and every course completed by student.

e) Retrieve the names and main departments of all straight A students (students who have a grade of A in all their courses).

f) Retrieve the names and main departments of all students who don’t have any grade of A in any of their courses.

Q2. State whether the given conclusions are true or false:

a) NOT (P(x) OR Q(x)) ⇒ (NOT (P(x)) AND (NOT (Q(x))))

b) NOT (∃ x) (P(x)) ⇒ ∀ x (NOT (P(x)))

c) (∃ x) (P(x)) ⇒ ∀ x (P(x))

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M911263

Have any Question? 


Related Questions in DBMS

Replacement china incproject descriptionyou work as an

Replacement China, Inc. Project Description: You work as an associate database manager at Replacement China, Inc. This firm specializes in finding difficult-to-replace, no-longer manufactured china, crystal, silver, and ...

Capstone project purpose of the assessmentthe purpose of

Capstone Project Purpose of the assessment: The purpose of this assignment is to identify new learning, self realisation and plan for improvement. Students will have an opportunity to explore the use of the online tools ...

Dfd1 draw a context diagram for the fiat for football

DFD 1. Draw a Context Diagram for the FIAT for Football process. 2. Draw a top level Data Flow Diagram for the FIAT for Football method. 3. Blow up any one non-trivial process into a first level Data Flow Diagram.

A task descriptionoverviewyour task is to create and test a

A. Task Description Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may ...

Assignmentcreate a simple excel spreadsheet with data to

Assignment Create a simple excel spreadsheet with data to update the database. 1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wiz ...

Career opportunities in your majorknowledge workers

CAREER OPPORTUNITIES IN YOUR MAJOR Knowledge workers throughout the business world are building their own desktop databases (often called end-user databases or knowledge worker databases). To do so, they must understand ...

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Query 1list all movies played in landmark or music box

Query 1 List all movies played in Landmark or Music Box. Output only titles and eliminate duplicates. Query 2 List all stars born after 1960. Order them by their birthdate in ascending order. Output their first names, la ...

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen