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
What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

The H. I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of graduates in 1965. The school keep

Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th

What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

Add generation capabilities and/or tailor the built-in functionality of generator. This enables you to produce "all" the test data for the MySQL tables you produced in the previous

The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the

I want a good Microsoft Admin experienced in IIS and SQL Server. They require being able to set it up and administer from then onwards. Experience in Team Foundation Server a