Exam (elaborations)
CIS2750 Exam Guide With Complete Solution
- Course
- Institution
CIS2750 Exam Guide With Complete Solution...
[Show more]
Content preview
CIS2750 Exam Guide WithComplete Solution
What does the SQL join operation do - ANSWER select data from two or
more tables by conceptually joining tables by a common column
cross join - ANSWER operates like the cartesian product, two tables are
multiplied together to a new table
inner join - ANSWER tables are combined based on a common column (we
used this)
outer join - ANSWER combining all rows of one table with only the matching
rows of another table
self join - ANSWER a table is joined to itself, key word that is used is as
what operator represents joins - ANSWER equals sign
aliasing in sql - ANSWER creating queries with shorter table names by
aliasing the table name to an abbreviation
three types of outer joins - ANSWER left, right, and full
view in SQL - ANSWER a view is a virtual table, that does not really exist but
appears to the user as it did
base tables in SQL - ANSWER real tables that actually exist and require
storage
when can views be updated - ANSWER only when they are a simple row and
column subset of a base table they cannot be a join
, flaws of sql - ANSWER strictly declarative, limited data types, redundant,
negative effects
what sql lacks - ANSWER time varying tables
why is interface design important - ANSWER interface can be the only
contact user has with the system
conceptual model - ANSWER system designer's way of representing the
system to the user
what advances enabled the shift from user interfaces to graphical user
interfaces - ANSWER cheap RAM, Success of raster graphics, fast and cheap
CPUs
characteristics of a GUI - ANSWER graphical, objects, actions
characteristics of direct manipulation systems - ANSWER system is portrayed
as an extension of the real world, there is continuous visibility of objects and
actions, actions are rapid and incremental with visible display of results,
incremental actions are reversible
characteristics of indirect manipulation systems - ANSWER uses words and
text (typing instead of pointing)
advantages of GUIs - ANSWER symbols: easy to recognize, learn, and aid in
problem solving
errors can be prevented because not allowed through input,
reduces need for typing skills,
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Newsolution. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
71250 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 15 years now
Recently viewed by you
Package deal ·
Samenvattingen HBO rechten jaar 1 blok 3
Package deal ·
Alle stof tentamen leerjaar 2 periode 4
Exam (elaborations) ·
GIZMO WITH COMPLETE SOLUTIONS 100%2023/2024
Exam (elaborations) ·
CT EXAM #2 QUESTIONS WITH COMPLETE ANSWERS
Exam (elaborations) ·
NR 507 WEEK 7 QUIZ 3 - QUESTIONS AND ANSWERS
Exam (elaborations) ·
NR 507 WEEK 7 QUIZ 2 - QUESTIONS AND ANSWERS
