Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) prepare a detailed note on Referential Integrity.

problem 2) What do you understand by Decomposition of Relation Scheme?

problem 3) prepare down the functions of DBA.

problem 4) Distinguish between Weak Entity and Strong Entity with appropriate ex.

problem 5) Consider the following database relations:

Country(Con-code, Name, Capital)
Population (Pop-code, Population)

Country and Population are related with one to one relationship.

Create relational database for the above and convert it in 3NF and solve the given queries in SQL :

(i) List highest population country.

(ii) Give name and population of country whose capital is ‘Delhi’.

(iii) Print Countrywise Population.

problem 6) Consider the given relation:

Teacher (tno, tname, collegename, dept.)
Etest (eno, testname)

Teacher and Etest are related with many to many relationship.

Create a relational database for the above and convert it in 3NF and solve the following queries in SQL:

(i) Count no. of teachers who passed ‘Set Exam’ of Computer Science.

(ii) Delete all teacher details of ‘Maths’ Dept.

(iii) Print total no. of teachers passing respective exam.

problem 7) Consider the following relation:
Employee (empno, empname, salary, comm., desg.)
Department (deptno, deptname, location)

Employee and Department are related with many to one relationship.

Create relational database for the above and convert it in 3NF and solve the following queries in SQL:

(i) Determine employees who are working at Ahmednagar city location.

(ii) Find maximum, minimum and average salary for every designation.

(iii) Update commission for every employee by 5% who belongs to ‘Computer Department’.

problem 8) Consider the given relation:

Item (I_no, I_name, I_qty)
Po (p_no, p_date, cost, qty)
Supplier (s_no, s_name, s_addr.)

Item and Po are related with one to many relationship and supplier and Po are related with one to many relationship.

Create a relational database in 3NF and solve the following queries in SQL :

(i) Find out po_no, po_date and supplier_name of Po which is maximum amount.

(ii) List name of supplier to whom Po is given for ‘Mouse’.

(iii) List name of supplier who is going to supply ‘Monitor’ with minimum cost.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Restaurants and fast-food chains rely heavily on business

Restaurants and fast-food chains rely heavily on business intelligence to make important decisions. Casinos do as well. Some of the leading restaurants, fast-food chains, and casinos using data warehouses include AFC Ent ...

Exercise 1 - html and Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance

Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance from center (KM) Available 1 Les Jardins du Marais 3 Internet 74 rue Amelot, Paris, 75011 2 True 2 Golden Tulip Little Palace 4 Internet Gym Parking Res ...

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

Database analysis and designimplement the initial database

Database Analysis and Design Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relat ...

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.

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

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

Database systems assignment - student enrolment database a

Database Systems Assignment - Student Enrolment Database A. Task Description 1. Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, de ...

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

  • 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