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

How up-to-date should data warehouse information

HOW UP-TO-DATE SHOULD DATA WAREHOUSE INFORMATION BE? Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making. Below is a list of decision-making processes that peop ...

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. ...

Movie theater database entity-relationship modeldevelop a

Movie Theater Database: Entity-Relationship Model Develop a Microsoft Access database based upon the below Entity Relationship Model. Be sure to include tables, fields, keys, relationships, and data in your database. You ...

Database design discusion 150 wordsnormalizationplease

Database Design Discusion (150 words) Normalization Please respond to BOTH of the following questions: Question A In your own words discuss the benefits of normalization. Question B Do you think we should normalize our d ...

Assignmentproject descriptionextreme h2o is a company that

Assignment Project Description: Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used f ...

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 ...

Assignmentdeliverablesall files are located in the

Assignment Deliverables All files are located in the subdirectory of the project. The project should function as specified: When you visit the Personnel form page (frmPersonnel.aspx), a record should be saved in the tblU ...

Data information decision please respond to the

"Data Information Decision" Please respond to the following: • With the obvious pace of current technology development, data continues to grow daily. Imagine that you are a Database Administrator for a large organization ...

Database normalizationnormalize the below orders table to

Database Normalization Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes). The following is a list of ...

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.

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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