Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) Consider the given relationships:

Doctor (doct_no, doct_name, doct_address, doct_city)
Hospital (hosp_no, hosp_name, street, hosp_city)
Doct_Hosp (doct_no, hosp_no, date)

Solve queries in Relational Algebra:

(i) Find hospital name to which Dr. Padghan has visited.

(ii) Determine all doctors who have visited hospital in the same city.

(iii) prepare name of hospital to which Dr. Shirsat has visited on 08/01/2010.

(iv) prepare all doctors who visited ‘Padghan Hospital’.

(v) prepare name of Hospital in ‘Shrirampur’.

problem 2) Consider the given relationships:

Player (pno, name, city)
Game (gno, name, place)
Player_Game (pno, gno, date)

Solve queries in Relational Algebra:

(i) Determine list of players playing ‘Cricket’.

(ii) Determine list of games played by more than 10 players.

(iii) Determine list of players and games played on ‘March 4, 2010’.

(iv) prepare all available games in India.

(v) prepare players playing cricket and football.

problem 3) Shramik Vidhyapit offers 10 courses on ‘Information Technology’.

Each course is conducted in several batches, where a maximum batch size is of 50 students. For every batch separate instructor is appointed. When for the particular course minimum 25 students get admitted, then the timetable is prepared and separate classrooms and also instructors availability, daily one hour is allocated to each batch. As numbers of students is growing, it is difficult to the management to schedule the course. Suggest a suitable information system to handle the above problem:

(i) Draw a Entity-Relation Diagram for Information System Design.

(ii) Convert Entity-Relationship Diagram into Relational Database in 3NF.

problem 4) Describe Degree of Relationship Type.

problem 5) Distinguish between Single Attribute and Multivalued Attribute.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Virtualization fundamentalsunit 3 research projectwrite an

Virtualization Fundamentals Unit 3 Research Project Write an overview of *any two* of the following topics. Each overview should be between one half and one full page long. You should use a minimum of two sources for eac ...

Lab creating a database designthis assignment contains two

Lab: Creating a Database Design This assignment contains two Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Note: If you are us ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Projectfalcor supplies is a distributor of high tech

Project Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The company's main compe ...

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

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

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

Discussionatleast 1 paragraph for each partpart 1 remote

Discussion Atleast 1 paragraph for each part Part 1: "Remote Access" Please respond to the following: • Remote access to corporate resources is becoming commonplace. From an auditing perspective, suggest two or more cont ...

  • 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