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

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

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

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

Tasks objectives1 manage client-server connections using

Tasks Objectives: 1. Manage client-server connections using RDBMS Net Services 2. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system 3. Manage Redo log inf ...

Advanced relational database final programming project in

Advanced Relational Database Final Programming Project In this project, you will design a secure database with several tables using good relational database design techniques. Project Objectives: After completing this Pr ...

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

Assignment business intelligence and data

Assignment: Business Intelligence and Data Warehouses Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a man ...

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

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

Question - databasesuse database software such as microsoft

Question - Databases Use database software such as Microsoft Access or LibreOffice Base to perform the following actions. (Refer to Workshops 9 & 10 for help.) A. Create a new database. Add tables based on the design of ...

  • 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