Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

1) What do you mean by database utilities? List a few common functions that the utilities perform.

2) What do you mean by a recursive relationship type? Provide some exs of recursive relationship types.

3) Consider a bank database taking care of accounts (saving, current, fixed deposit, flexi,....) and loans (house, auto, business,....). Assume it is essential to keep track of each account transaction (deposit, withdrawal, checks, ATMs,...) and loan payment. All transactions should include the amount, date, and time. Draw the bank schema and EER diagram. State any assumptions you make about additional requirements.

4) Describe the purpose of Boyce-Codd normal form and describe how BCNF differs from and is stronger than 3NF. Demonstrate your answer with suitable ex.

5) Given below are two sets of FDs for a relation R (A, B, C, D, E). Are they equivalent?

i. A→B, AB→C, D→AC, D→E

ii. A→BC, D→AE

6) What types of constraints are inclusion dependencies meant to represent?

7) Discuss the entity integrity and referential integrity constraints. Why is each considered important?

8) For relations Employee(name, ssn, sex, salary, superssn, dno); Manager(mgrssn, mgrjoindt); deptloc(dno, dloc); proj(pno, pname, ploc, dno); works(ssn, pno, hrs); dept(dname, dno, mrgssn); dependent(essn, deptname, sex, relationship).
prepare querries for the schema of figure in relational algebra.

i) Retrieve the names of all employees in department 5 who work more than 10 hours per week on the product X project.

ii) For each project, list the project name and the total hours per week (by all employees) spent on that project.

iii) Retrieve the names of all employees who do not work on any project.

iv) For each department, retrieve the department name and the average salary of all employees working in that department.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

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

Frontlines united states of secrets all Frontline's United States of Secrets, all

Frontline's United States of Secrets, all episodes: http://www.pbs.org/wgbh/frontline/film/united-states-of-secrets/ (Links to an external site.) Nova's Genome specials http://www.pbs.org/wgbh/nova/body/cracking-the-code ...

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure to the concepts relating to database systems and optimal strategies for efficient management of databases Learning Outcomes assessed: 1. Crea ...

Normalizationsuppose that you are the database developer

Normalization Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcom ...

Database design assignmentpart 1customer resource

Database Design Assignment Part 1 Customer Resource Management Database You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in ...

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

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

Database in-class assignment normalizationfor the following

Database In-class Assignment Normalization For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF. Movie Rating Showtime Theater The SpongeBob Movie PG 4:00 ...

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

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

  • 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