Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Q1. For the given problem definition:

A company database requires storing information regarding employees (identified through ssn, with salary and phone as attributes); departments (identified through dno, with dname and budget as attributes); and children of employees (by using name and age as attributes). Employees work in departments; each department is managed by an employee; a child should be identified exclusively by name when the parent (who is an employee; suppose that only one parent works for the company) is known. The information regarding a child is not needed once the parent leaves the company.

a) Sketch an E-R diagram.
b) Map the E-R diagram to the relational model.

Q2. Let consider the given relations with key underlined:

Customer (C#, Cname, Address)
Item (I#, Iname, Price, Weight)
Order (O#, C#, I#, Quantity)

prepare down the SQL queries for the given:

a) List out all the names of customers who have ordered items weighing more than 1000.

b) List out all the names of customers who have ordered at least one item priced over Rs.500.

c) List out all the customers who have ordered the similar item as the customer named ‘John’.

d) Make a view called “orders” which has the total cost of every order.

Q3. prepare down the fundamental operations in the Relational Algebra? Describe different joins in relational algebra with the help of appropriate illustrations.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

Data warehouse1 review the submission hokie resort

Data Warehouse 1. Review the submission Hokie Resort situation description to understand the problem domain(see Business Situation Description below) 2. Write the three most important questions that management must answe ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

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

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

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

Individual outsourcing risksprepare a 8- to 10-slide

Individual: Outsourcing Risks Prepare a 8- to 10-slide PowerPoint presentation, including speaker notes, that identifies the possible risks to an organization in each of the following outsourcing situations: • The use of ...

This assignment consists of two 2 sections a design

This assignment consists of two (2) 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 assignment. Label each file name accor ...

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

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

  • 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