User Account

All Pages

Explain the concept of physical data independence

Assignment Help Database Management System
Reference no: EM1379750

1. Explain the concept of physical data independence and its importance in database systems

2. Explain what problems are caused by the design of the following table.

The Customer table attached in complete requirement doc file

3. List four significant differences between a file-processing system and a DBMS.

4. Describe the differences in meaning between the terms relation and relation schema.

5. List two reasons why null values might be introduced into the database.

6. Write the following queries in SQL, using the university schema. (Appendix A, page 1271)

a. Find the titles of courses in the Biology department that have 4 credits.

b. Find the lowest salary of instructor in Comp. Sci. department.

c. Find the enrollment of each section that was offered in Fall 2011.

d. Find the minimum enrollment, across all sections, in Fall 2011.

e. Find the sections that had the minimum enrollment in Fall 2011.

7. Write the following queries in SQL, using the university schema. (Appendix A, page 1271)

a. Find the names of all students who have taken at least one Comp. Sci. course; make sure there

are no duplicate names in the result.

b. Find the IDs and names of all students who have not taken any course offering before Spring

2009.

c. For each department, find the maximum salary of instructors in that department. You may

assume that every department has at least one instructor.

d. Find the highest, across all departments, of the per-department maximum salary computed by

the preceding query (part 7.c).

e. Find the course titles of all prerequisite courses of "CS-315".

8. Write the following queries in SQL, using the university schema. (Appendix A, page 1271)

a. Create a new course "CS-001", titled "Weekly Seminar", with 1 credit.

b. Create a section of this course in Fall 2011, with sec_idof 1.

c. Delete the course CS-001. What will happen if you run this delete statement without first

deleting offerings (sections) of this course?

9. Show that (proof), in SQL, <>all is identical to not in.

10. Show how to define a view total_credits(year, num_credits), giving the total number of

credits taken by students in each year. a


Download:- requirement.rar

Reference no: EM1379750

Questions Cloud

Printf statement to debug an application : There are various ways to debug a program, perhaps most elementary is using a printf() statement to show important pieces of data regarding the program execution point,
How does framing a message affect communication process : How does framing a message affect communication process. How could your message be reframed so that it is processed also received with improved results.
Briefly explain what two parameters on x-axis also y-axis : briefly explain what two parameters on X-axis also Y-axis mean also provide an example for each explanation.
Evaluate purpose also usefulness of these surveys : We see surveys on all kinds of store receipts allowing consumers to give feedback in exchange for being entered into a drawing for a prize. Evaluate purpose also usefulness of these surveys. Consider all stakeholders in your answer.
Explain the concept of physical data independence : Explain the concept of physical data independence and its importance in database systems,  List four significant differences between a file-processing system and a DBMS.
Crontab script for various jobs : Construct a crontab to perform tasks given below at the frequencies specified. Run a backup script named local-backup from the /usr/local/adm directory every weekday at 11:30pm.
Discuss two strategic reasons for companies to engage : Briefly discuss two strategic reasons for companies to engage in practice of countertrade. Assuming that your company has decided to get involved in countertrade.
What are strengths of such an organization : Transnational Solution" suggests that technical also marketing functions be integrated within each subsidiary of any organization. What are strengths of such an organization. What are weaknesses or pitfalls.
Are following objective functions for an lp model equivalent : Are following objective functions for an LP model equivalent. That is, if they are both used, one at a time, to solve a problem with exactly same constraints, will optimal values of X1 also X2 be same in both cases.

Reviews

Write a Review

Database Management System Questions & Answers

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Key value of fourth index record on top level

What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block of the next level down?

  Create a database for a home-budgeting application

The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from the MySQL console command line.

  Write functional dependencies in table concerns invoicing

Write the functional dependencies in the following table that concerns invoicing (an application Premiere Products in considering adding to its database), subject to the specified conditions.

  Create relational schema of database in 3nf

A Relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys, candidate keys, and which attributes are nullable, giving reasons. List any assumptions you need to make.

  Your task is to develop a database to support this activity

Your task is to develop a database to support this activity.Here is what you need to be able to provide Custom Auto Body in order to land your first consulting contract:

  Explain denormalized table in normal form

The DBA denormalized some of the data in the Premiere Products database to improve performance. Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table?

  Ways of implementing one-to-one relationships

Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, and phone numbers)

  What do you mean by data base scheme

Database Questions:  What do you mean by data base scheme?  What do you mean by cardinality ratio?   What do you mean by degree of relation?

  Explain steps of process in increasing cardinalities

When increasing cardinalities from 1:N to N:M, which of the given steps are included in process the order of steps listed below is not relevant, only steps themselves?

  Create a database design specification

Create a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd Normal Form.

  Describing the select statement

Data processing needs taking or receiving the data from a source and doing something with it. The same can be said about the transaction processing. When working along with a file, whether it be a fixed length.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd