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

What is predictive modelling, Problem: (a) Data mining is one of the b...

Problem: (a) Data mining is one of the best ways to analyse data and using software techniques, hidden and unexpected patterns and relationships in sets of data can be extrac

What are the several forms of identity, What are the several forms of ident...

What are the several forms of identity? a) Value b) Name c) Built-in

I need helpin assignment, My cut off date is very soon in a Database subjec...

My cut off date is very soon in a Database subject and i dont know how to solve anything in it

Explain retrieval in qbe, Explain retrieval in QBE? Retrieval in QBE : ...

Explain retrieval in QBE? Retrieval in QBE : A "GUI" for expressing queries. Based on the Domain Relational Calculus (DRC) Actually invented before GUIs. Very co

Explain the three data anomalies, What are the three data anomalies that ar...

What are the three data anomalies that are similarly to take place as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why n

Need some database of usa and uk, I want Database Of United Kingdom with Cr...

I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme

What is rdbms, What is RDBMS? Relational Data Base Management Systems (...

What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be formed and

What is dml query langauge, What is DML Query Langauge? Data Manipulati...

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

BMIS 351, Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work...

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

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