Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) Create two tables company_info with fields, emp_id, name, city, salary, designation, date_of_joining and personal_info with fields name, city, address, DOB, and phone_no.
Carry out the following query:

1) Insert five records to each tables?

2) Perform subquery?

3) Perform Union operation?

4) Perform intersect operation?

5) Perform minus operation?

6) Create the table by selecting from another table?

7) Delete one record using emp_id as condition?

8) Show records using between operator where experience is between 1 to 8 years?

9) Insert 6 records?

10) Modify the table by adding field experience?

problem 2) Create 2 tables customer with fields customer_id, customer_name, customer_street, customer_city and depositor customer_id, account_number, balance Set relation between the two tables:
Perform the following query:

1) Show the records of depositor tables?

2) Show customer_id, customer_street, account_number, balance whose customer_id is between c00001 and c00002?

3) Show depositor table whose customer_street is ‘mg-road’?

4) Show the customer records whose balance is between 20000 and 40000?

5) prepare down the records of customer table whose account_number is between 300 and 500?

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Systems and database design assignment database design amp

Systems and Database Design Assignment: Database Design & Implementation (Airline) The assignment consists of two tasks. The first task, Database Design, requires a word processed document in PDF format detailing the des ...

Design a relational database for a video rental store the

Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1,200 DVD titles. There are 25 supplier ...

Coit20247 database design and development assignmentyou

COIT20247 Database Design and Development Assignment You must use that sample solution of assignment only for the following tasks: Assessment task- 1. Normalization a) Map the ERD, from the sample solution, into a set of ...

Databaseplease read carefully and if u sure u can do it

Database Please read carefully, and if u sure u can do it email me., please Design a database (entity and relationship tables in Access) for a small college department library. You should have the entities and relationsh ...

Database design and implementationtask 1 - database

Database Design and Implementation Task 1 - Database Design Your first task is to design a database for the scenario detailed on the following pages. Your final database design should comprise of approximately 10 entitie ...

List the different types of locks used by dbms systems and

List the different types of locks used by DBMS systems and explain how they differ from each other. Additionally, suggest the suitable scenario for each of them. 400 to 500 words, at least 4 references with one website r ...

Database systemretail store database Database system Retail Store Database: Relationships

Database system Retail Store Database: Relationships • Conduct an in-depth examination and analysis of the database, Week2_RetailStore.accdb . Apply the concepts of database systems that you have learned this week. For e ...

Database relationsusing the invoice table structure shown

Database Relations Using the INVOICE table structure shown in Table, do the following: ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE INV_NUM 211347 211347 211347 211348 211349 PROD_NUM A ...

Overviewfor this assignment you will implement and query a

Overview For this assignment you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create the database structures, to fill the database with da ...

Data mining is a powerful and tool but it poses challenges

Data mining is a powerful and tool, but it poses challenges to the protection of individual privacy. Data mining can combine information from many sources to create detailed profiles about each of us. Explore the Web sit ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate