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

Assignmentthis assignment requires you to design a video

Assignment This assignment requires you to design a video rental database system that will provide the functionality outlined below. Your grade will be based on how well your system can accommodate the requirements, your ...

Unlimited pickers is a group of workers who have joined

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to l ...

Oracle databaseusing the schema you developed in homework 1

Oracle Database Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns an ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

Ngocbo database projectthe purpose of this project is to

NGO/CBO Database Project The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Database Specifications In view of ...

The discussion questionbased on your research and readings

The discussion question Based on your research and readings for the week, respond to the following discussion topics. • Often, systems have only one level of security when it comes to databases. Imagine that someone is t ...

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

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

This assignment consists of two 2 sections a design

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name accor ...

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

  • 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