Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) Create the sales order database of 2 tables Sales_order and sales_order_detail with the following fields-

Sales_order                                                   Sales_order_detail
S_order_ no                                                           s_order_no
S_order_date                                                         product_no
Client_no                                                                Qty__oredered
Salesman_no                                                          product_rate
Dely_date
Order_status

Set relationship between two tables.

Queries:

1) Name all the orders that are cancelled in the month of March?

2) Demonstrate all details of sales_order whose S_order_date is ’12-jan-96’ and whose product_no is ‘P00001’?

3) Show all records of sales_order_detail where the salesman_no is between ‘S00001’ and ‘S00005’?

4) Show client_no, S_order_date, salesman_no where the dely_date is ’26- may- 96’?

5) Display all record whose Qty_ord ered is >=10?

problem 2) Create two tables:

1) stud_info with fields as roll, name, address, Date_of_addmission, fees

2) Stud_marks with fields as roll, sub1, sub2, sub3, total

Now answer the following:

1) prepare down the syntax for creating the two table with primary key and foreign key as roll for both the table?

2) Print the student’s information who has taken admission in month of February?

3) Print the student’s information those has n as the 3 letter in their name?

4) Print the marks of the student whose roll no is same as the roll no of the student whose admission date is ‘2-jun-06’?

5) Print the marks of sub2 who has got more than 20 marks?

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

1 how are qbe tools and sql similar2 how are they

1. How are QBE tools and SQL similar? 2. How are they different? 3. What is a data warehouse? 4. How does it differ from a database?

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

Analytical assignment individual or group of max two

Analytical Assignment (Individual or Group of Max two students) What is Research article? Review articles provides summary of current state of the research on a particular topic. Ideally, the writer searches for everythi ...

Your team is a consulting company that specializes in rapid

Your team is a consulting company that specializes in rapid application development. A client company wishes to improve their customer data and interactions records. You create a simple customer relationship system for t ...

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Create a data definition class to model one product sold at

Create a data definition class to model one product sold at a bakery. The product will have a description, cost, and quantity in stock. Instance methods include: accessors for each instance variable, non-validating mutat ...

Assignment business intelligence and data

Assignment: Business Intelligence and Data Warehouses Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a man ...

Case problem-global site gps - kevin hodge is a production

Case Problem- Global Site GPS - Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin's jobs is to monitor output at the company's fi ...

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

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

  • 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