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

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

Project database and programming designthis assignment

Project: Database and Programming Design This assignment consists of two 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 a ...

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

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

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

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

Capstone project purpose of the assessmentthe purpose of

Capstone Project Purpose of the assessment: The purpose of this assignment is to identify new learning, self realisation and plan for improvement. Students will have an opportunity to explore the use of the online tools ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

Homeworkunlimited pickers is a group of workers who have

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

  • 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