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
This report identifies and outlines my CIS 499 project named Traffic Data Management  Systems (TDMS) .   My goal is to design a replica of all traffic issues to be implemented i

Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD

Differentiate between Procedural and non procedural languages ? Procedural and non procedural languages - A procedural language specifies the operations to be performed on th

List and also explain the dissimilar stages of DDLC ?

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

Flights(FlightNo, DeptDateTime, Origin, ArrivalDateTime, Destination, Capacity, SoldSeats) Tickets(FlightNo, Seat, CustID) Where - flightNo is the PK of the flights table - DeptDa

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Extend your CREATE TABLE statement from problem 3 with referential integrity constraints. Updates and deletes on related rows are restricted. 6. From examination of the sample data

What do you understand by ACID? - ACID (Atomicity Consistency Isolation Durability) is a quality sought after in a reliable database. Here's the relevance of each quality:

Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t