Visio diagram - database, Database Management System

Assignment Help:

The database depicted in the Visio diagram describes Proceeding, Article, Researcher, article PublishedIn a proceeding, article WrittenBy researchers and proceedings EditedBy researchers.

  1. Proceeding(ISBN, bookname, year, publisher): lists all the proceedings in existence, with the proceeding title, the year of publication and the publisher
  2. Article(aID, title, subject): lists all the articles
  3. Researcher(rID, name, institution): lists all the people, including editors and authors, and their institution
  4. PublishedIn(aID, ISBN): For each proceeding, lists the article contained
  5. WrittenBy(rID, aID): For each person, lists all the article he/she has authored, one article can be co-authored by more than one
  6. EditedBy(rID, ISBN): For each proceeding, lists all its editors, there can be more than one

There are no duplicate rows in any of the tables.

Please read the script 10.sql carefully. It both defines and creates the sample database and has placeholders for putting in your answers.

You are supposed to produce the following queries. Most of them produce answers without modifying the database. For each such query, unless stated otherwise;

  1. Sort the results in ascending order
  2. Remove duplicates from the answer

So to assuming your answer without the above requirement, on a hypothetical database would have been:

SELECT a, b
...;

You should actually have:

SELECT DISTINCT a, b
...
ORDER BY a ASC, b ASC;

You may, of course, use intermediate tables while producing your answers. You may need to explicitly DROP them once the answer is produced, so that you can run your queries again without getting errors.


Related Discussions:- Visio diagram - database

Compare the efficiency of the two mining processes, Consider the following ...

Consider the following database containing five transactions. Let min_sup = 60%. Mine all frequent itemsets using Apriori and FP-growth algorithm. Compare the efficiency of the t

Unnormalize form, employee(empid,empname,dept,telno,mobno, add,sssno,tinno,...

employee(empid,empname,dept,telno,mobno, add,sssno,tinno,WEdates,WEcomp,WEadd,WEpos,WEres) this is a employee record which is need to be normalize.the WE means work experience

Note gate, i want notes on this topic

i want notes on this topic

How to apply the bcnf decomposition , Consider the following relational sch...

Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non

Ans the following, discuss the array implementation of a stack.

discuss the array implementation of a stack.

Oracle fusion middleware, Oracle Fusion Middleware: Key Skills: Consul...

Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

What is called block-level striping, What is called block-level striping? ...

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers

Database Management System, Assume that you are responsible for selecting a...

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Example database application, We will explain here an example database appl...

We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts. College database remains track of faculty, Stu

Define the term domain, Define the term Domain. For each n every attrib...

Define the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.

Write Your Message!

Captcha
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!

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