Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1:

Design the ER diagram for an XYZ Information Technology Training Institute which would meet information requirements for their training programmes. Clearly indicate entities, relationships, cardinality and the key constraints. The explanation of the environment is as follows:

Institute has 15 instructors and could handle upto 100 trainees for each training session. Institute offers 5 advanced technology courses, each of which is taught by the team of 2 or more instructors. Each instructor is allotted to the maximum of two teaching teams or might be assigned to do research each trainee undertakes one Advanced technology course per training session.

problem 2: 

Staff No.    Branch No.    Branch Address                    Name     Position      Hrs/Week
E101           B02             Sun Plaza, Delhi, 110001     Rahul       Assistant     16
E101           B04             2/3 UT, Delhi, 110111         Rahul       Assistant     9
E122           B02             Sun Plaza, Delhi, 110001     Medha     Assistant     14
E122           B04             2/3 UT, Delhi, 110111         Medha     Assistant     10

Do the Normalization for above given table.

problem 3:  

Describe how “GROUP By” clause works. What is the difference between the WHERE and HAVING clauses? Describe them with the help of ex for each.

problem 4:   

Given the relational schema:
ENROL (S#, C#, Class) - S# represents student number
TEACH (Prof, C#, Class) - C# represents course number
ADVISE (Prof, S#) - Prof is project guide of S#
PRE_REQ (C#, Pre_C#) - Pre_C# is prerequisite course
GRADES (S#, C#, Grade, Year)
STUDENT (S#, Sname) - Sname is student name

Give queries expressed in relational algebra, tuple calculus and domain calculus for the following:

(i)   List all students taking courses with Prof Ashok.

(ii)  List all student names who have chosen Prof Rahul as project Guide.

(iii) List those professors who teach more than one class.

(iv) List all student names who got Grade A in the year 2012 in C# P202.

(v)  List all students who have taken the pre-requisite course Pre_C# P304.

Note: Make appropriate assumptions, if any.

problem 5: 

What are the advantages of indexed-sequential file organisation? With the help of the ex describe the structure of indexed-sequential file.

problem 6:   

prepare the differences between Hierarchical, Network and Relational data models with the help of appropriate exs. Describe why relational data model is a better choice over the two. Justify the answer.

DBMS, Programming

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

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

Data information decision please respond to the

"Data Information Decision" Please respond to the following: • With the obvious pace of current technology development, data continues to grow daily. Imagine that you are a Database Administrator for a large organization ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

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

The discussion questionbased on your research and readings

The discussion question Based on your research and readings for the week, respond to the following discussion topics. • Often, systems have only one level of security when it comes to databases. Imagine that someone is t ...

Organizations want information organizations need

Organizations want information. Organizations need information. However, information must be in an organized format that supports the creation of business intelligence. Otherwise, according to Rebecca Wettemann, vice pre ...

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

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

  • 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