Thomas, J. Assignment 6-2

docx

School

University of Michigan, Flint *

*We aren’t endorsed by this school

Course

344

Subject

Computer Science

Date

Nov 24, 2024

Type

docx

Pages

2

Uploaded by bucebuce1

Report
Assignment 6-2 Professor Sherry Jerome-Stebens Due October 14, 2010
Page 1 D1. Many relational algebra operators are allowed complete manipulation of relational database tables, and that most basic queries are covered by only three operators: Project, Select, and Join. An advantage of SQL over relational algebra is where users must learn different syntax for each of the various relational algebra operators. SQL information retrieval queries follow a structure, predefined syntax. A disadvantage of relational algebra is that each operator must be accomplished in a separate query. Two queries need to be executed to accomplish the two operations. This type of limitations is why Structured Query Language (SQL) was developed. D2 . An advantage of SQL is its ability to enable the performance of multiple operations in a single query. The use of a standard format for every query would simplify the task of query development, which had proven to be very difficult for many users. Although most relational database software can run queries that are created in SQL form and most packages offer an interface intended to make querying have more of a point-and-click feel. Such an interface is called Query By Example (QBE). This type of query allows the user to provide an example of what they want the answer to look like. The user does not need to learn SQL code to generate many useful queries. A user must understand what the different elements of the QBE interface accomplish when developing a query.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

DHS covid.docx
HW 08.pdf
IMG_2749.jpeg
IMG_2189.jpeg
Screen Shot 2023-03-15 at 7.03.41 AM.png
attachment_1 (5).pdf
2023-07-31 (1).png
B4B56375-784B-430A-9730-7469F44278FC
CS 4402 DF 8.edited.docx
Lab 7 status report .docx
EE5731_Questions_updated_7-7.pdf
2.05_task1.docx
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS