Visio diagram - database, Database Management System

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.

Posted Date: 2/22/2013 6:19:26 AM | Location : United States







Related Discussions:- Visio diagram - database, Assignment Help, Ask Question on Visio diagram - database, Get Answer, Expert's Help, Visio diagram - database Discussions

Write discussion on Visio diagram - database
Your posts are moderated
Related Questions
State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi

Boyce-Code Normal Form (BCNF) A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3N

Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

Difference between LEFT OUTER JOIN and RIGHT OUTER JOIN In left outer join tuples from the left-hand-side relation which do not match any tuple in the right-hand-side relation

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

Project Description: My VBulletin forum was hacked, and soon after my server machine died. So, I'm now on a new machine, and I think that I've taken care of 99% of the hacking..

how many hourse have been spent on a certain project

Which database level is closest to the users? External database level is closest to the users.