Be on schedule.Score better.

support@savemydegree.com

EN

Our Services

Get 15% Discount on your First Order

Assignment#1 MSIT 630 Database SystemsTotal: 60 points1. Explain the concept of physical data independence and its importance in database

Assignment#1
MSIT 630 Database Systems

Total: 60 points

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

points)

2. Explain what problems are caused by the design of the following table. (4 points)

The Customer table

3. List four significant differences between a file-processing system and a DBMS. (4 points)

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

points)

5. List two reasons why null values might be introduced into the database. (4 points)

6. Write the following queries in SQL, using the university schema

( and

execute your SQL statement on the sample database with small relations

(

dir/smallRelations/smallRelationsInsertFile.sql) and show me both the SQL statements and the

query results. (20 points, 4 points each)

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

b. Find the name(s) of the instructor(s) who DON’T earn the lowest salary in the Physics

department.

c. Find the enrollment of each section (number of students enrolled) that was offered in Fall

2017.

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

e. Find the course ID and section ID of the sections that had the minimum enrollment in Fall

2017.

7. Write the following queries in SQL, using the university schema

( and

execute your SQL statement on the sample database with small relations

(

dir/DDL.sql
dir/smallRelations/smallRelationsInsertFile.sql
dir/smallRelations/smallRelationsInsertFile.sql
dir/DDL.sql
dir/smallRelations/smallRelationsInsertFile.sql

dir/smallRelations/smallRelationsInsertFile.sql) and show me both the SQL statements and the

query results. (20 points, 4 points each)

a. Find the names of all students who have taken at least two courses offered by Comp. Sci.

department; make sure there are no duplicate names in the result. Note that students in other

departments can take courses from Comp. Sci. as well.

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

c. For each department, find the name and salary of the instructor who earns the minimum salary

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 minimum salary computed by

the preceding query (part 7.c).

e. Find the course titles of all prerequisite courses of “CS-319”.

dir/smallRelations/smallRelationsInsertFile.sql

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Operational Excellence Week 9 AssignmentInformation

Operational Excellence Week 9 Assignment Information Systems for Business and Beyond Questions: · Chapter 9 – study questions 1-10, Exercise 3 &4.  (Chapter 6 | 219) 01. Describe the role of a systems analyst. 02. What are some of the different roles for a computer engineer? 03. What are the duties

Question attached.    Week 1 Data Visualization Article Summary Read the “

Question attached.    Week 1 Data Visualization Article Summary Read the “ Data Visualization: A Comprehensive Overview ” research article and write a one-page summary about it. Focus on how data visualization is defined, the strengths and weaknesses of the human visual system, and the analytical process. The summary must

Operational Excellence Week 8 Midterm

Operational Excellence Week 8 Midterm Midterm Exam Please a topic from the below list and create a one-page essay answering the question noted below.     · Define the IT organizational structure and how the IT organizational structure impacts culture and change management practices.  Additionally, how does the organizational structure impact

Instructions are posted.CMIS 320 Project 2IntroductionThis assignment allows students to demonstrate their skills in designing relational data

Instructions are posted. CMIS 320 Project 2 Introduction This assignment allows students to demonstrate their skills in designing relational databases to satisfy specific business rules and requirements. The deliverables for this assignment include an Entity Relationship Diagram (ERD) and the associated detailed documentation describing the database design and structure. In

2OutlineStudent’s Name Institutional Affiliation Course Name Instructor’s Name Date

2 Outline Student’s Name Institutional Affiliation Course Name Instructor’s Name Date Outline I. Introduction A. Definition of digital signatures B. Importance and applications of digital signatures C. Thesis statement and overview of the paper II. Detailed Description of Digital Signatures A. Cryptographic principles behind digital signatures 1. Public key cryptography

2OutlineStudent’s Name Institutional Affiliation Course Name Instructor’s Name Date

2 Outline Student’s Name Institutional Affiliation Course Name Instructor’s Name Date Outline I. Introduction A. Definition of digital signatures B. Importance and applications of digital signatures C. Thesis statement and overview of the paper II. Detailed Description of Digital Signatures A. Cryptographic principles behind digital signatures 1. Public key cryptography