Blog

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

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)

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

(https://codex.cs.yale.edu/avi/db-book/university-lab-dir/sample_tables-dir/DDL.sql) and execute your SQL statement on the sample database with small relations (https://codex.cs.yale.edu/avi/db-book/university-lab-dir/sample_tables-

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

(https://codex.cs.yale.edu/avi/db-book/university-lab-dir/sample_tables-dir/DDL.sql) and execute your SQL statement on the sample database with small relations (https://codex.cs.yale.edu/avi/db-book/university-lab-dir/sample_tablesdir/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”.

Related posts:

  1. Research Project Instructions: Sustainable Development: Research Paper: Each student should identify an area overburdened by pollution, applying EPA’s EJScreen: Environmental Justice Screening and Mapping Tool (https://www.epa.gov/ejscreen), which combines environmental and socioeconomic information in the area. Then, she needs to write a paper between six and eight pages (including figures, tables, and references). See the required format below. EJSCREEN is an environmental justice mapping and screening tool that provides EPA with a nationally consistent dataset and approach for combining environmental and demographic i
  2. The Assignment: Choose one historical concept about the Dahomey women warriors addressed in Edna Bay’s “Women in Combat,” a review of Stanley B. Alpern’s text Amazons of Black Sparta: The Women Warriors of Dahomey. Then in a five-page critical analysis – using a Womanist, Afrofuturist framework – that discusse
  3. explain what you see as a key problem or problems with the role of the class action in modern civil litigation. In doing so, make sure you explain how class actions differ from ordinary civil litigation, and create additional challenges.
  4. complete two discussion forums during the course.  Each consists of an initial post of 400-500 words addressing an instructor-provided topic.  The forums also require responses to the posts of at least two classmates. Each response should be 150-300 words.