User Account

All Pages

IN2213-G3 Database Systems Management Assignment

Assignment Help PL-SQL Programming
Reference no: EM132555594

IN2213-G3 Database Systems Management Assignment

Question 1

As an independent consultant you have a contract with Pures College to develop an application to support course administration. Read the following detailed description of this application, and complete the tasks listed below.

• A course has a unique course number and title, and is assigned to one or more areas of Information Systems Business Analysis. Each course has an instructor, at least one teaching assistant, an online conference whiteboard, a time interval, and a capacity (maximum number of students). A course need not be offered each term, but the challenge option is open the entire year. A course can have prerequisite courses. Students are not allowed to register for a course if they have not received credit for the prerequisites, or a course equivalent to the prerequisites. A student who would like to challenge a course should also have received credit for the course prerequisites, or have an authorization from the course's instructor.

• An instructor has a first name, last name, email address, phone and fax numbers, and has acquired several areas of expertise. Note that two different instructors may have the same (first or last) names, and/or share the same fax number.

• A student is given a unique student number. For each student, we want to record first and last name, email address, phone number, mailing address, and GPA. Again, the same names may belong to two different individuals. Each term, a student may be enrolled in several courses. For each enrolment, we want to record the grade. We have two types of students: graduate and undergraduate. Undergraduate students have a study major, while graduate students have a specialization and a thesis topic.

• A teaching assistant is a graduate student, and we need to record their first and last name, year of study, GPA, and the number of courses (including the current one) the teaching assistant has taught. A research assistant is a student for whom we want to record the usual basic information, as well as the number of years of work experience. The research assistant provides lab support for students, manages the conference whiteboard, and does some programming tasks.

• An area of Information Systems Business Analysis is described by its name. An area may be divided into several sub-areas. Each area is used to categorize the instructors, as well as the courses. For example, the area of Multimedia consists of the sub-areas of Graphics, Networking, and Human-Computer Interaction; the area of E-Services Technology consists of Artificial Intelligence, Networking, and Distributed Systems.

Hint: For each relation without a unique attribute or combination of attributes, introducing an artificial primary key might be a good idea.

Q1. Design and draw a complete E-R diagram for this course administration application, including all aspects discussed in IN2203. Clearly state any additional assumptions you made, but note that you must not override the above specifications.

Q2. Convert your E-R diagram into a relational schema. To describe a relation, specify its name, attribute names, primary key, and any existing foreign key. Explain the major design decisions, such as the choices you made to represent the relationships of the E-R diagram.

Question 2

Answer the following questions. (250 words max/question)
Q1. What are the main goals of RAID technology? How does it achieve them?
Q2. How does disk mirroring improve reliability?
Q3. What techniques are used to improve the performance of disks in RAID?
Q4. Suppose you use RAID level 0+1 (striping and mirroring) to do blockwise striping over 4 disks, and you have mirrored the data on another 4 disks. Under optimal circumstances (i.e., equal
distribution of requests, perfect load balancing), the number of block read accesses allowed by the RAID system would be . Explain your answer. a. the same as for a single disk
b. two times higher than a single disk
c. four times higher than a single disk
d. eight times higher than a single disk

Attachment:- Database Systems Management.rar

Reference no: EM132555594

Questions Cloud

A description of the major theme of the book : A description of the major theme of the book. Describe the main theories and principles (at least five) presented in the book.
Increasing levels of an experimental repellent : In your study of E. coli chemotaxis, you add increasing levels of an experimental repellent. If the repellent is truly effective
Understanding the mouse bloodstream : Certain bacteria have the ability to produce capsules that allow them to hide from a host's defenses. Before bacteria
What occurred in the dialogue including social work practice : Explain your interpretation of what occurred in the dialogue, including social work practice or theories, and explain how it might relate to assessment
IN2213-G3 Database Systems Management Assignment : IN2213-G3 Database Systems Management Assignment Help and Solution - What are the main goals of RAID technology? How does it achieve them
Fast food franchise : Choose two fast-food franchises and examine their facility layouts. Compare and discuss the differences in their layouts.
Prepare people for the job force versus preparing : What extent should the educational system prepare people for the job force versus preparing them to think critically? Which is more important in your view
Define one sociological theory : Define one sociological theory from our readings/materials that relates to your chosen social problem and analyze how this theory helps us better
Housekeeping genes in bacteria : You are working as an intern for a researcher who studies "housekeeping" genes in bacteria, particularly those that encode

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

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