






Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A comprehensive overview of relational database concepts and dbms fundamentals. It covers key topics such as relational models, schemas, constraints, sql queries, and dbms architecture. Exercises and complete solutions, making it a valuable resource for students studying database management systems.
Typology: Exams
1 / 12
This page cannot be seen from the preview
Don't miss anything!
CMPT 454 L1 - Intro Exam With Complete Solutions 100% Verified
"Relational DB uses the _________ model: Entities and Relationships are represented by ___________, ___________" relational, relations, tables
What needs to be determined to create a relational model of a real-world enterprise?
Within a table, ROWS represent _______ or _______ records, tuples
Are records unique? Yes
A primary key can be made up of ______ or _______ ______________ one or more attributes
Within a table, each column represents an ___________. Do columns have to be unique? attribute
yes
Table is also considered an instance of a _____________ schema
Where are schemas defined? In the DB
Where is the schema stored? system catalog
Would Schemas be considered a part of the meta data? Yes
Schema is associated with what? One or more constraints
Multiple table queries generally entail what? Joins
or at least similar operation
Can joins be cheap processing? What 'O' algorithm are joins No, they are expensive
~ O(n²)
________ must determine which join algo to use in _____ ______ __________ DBMS any given query
______ facilitates access to DBs DBMS
An application uses a __________ _____ when interacting with a DB. Give examples of how information is related to schemas conceptual view
tables, columns, domains, etc
DBMS maps the ________________ view to the ________ view. conceptual, physical
Data is stored in ________ ________ or ________ _______ while using most efficient access methods, examples being... main memory or secondary storage
indexes
DBMS is responsible for ____________ data from ______ ___________ accessing data from storage devices
Why use a DBMS? To store data for:
Additional issues a DBMS can handle are
DBMS is linked to application @ compile time (same address space)
Where are embedded DB applications often used? mobile systems
Tiered Client-Server application Application connects to DBMS via ODBC, JDBC, etc
May entail connecting to a server that connects to a DB server
Application and DBMS are considered combined or separate machines. separate
Through what does an Application and DBMS communicate? a network
In a tiered architectures, the different number of tiers can refer to
Client-Server architecture is common with what type of DBMS? Enterprise DBMSs
Describe DBMS functionality Manages the following:
What does it mean to manage data manipulation language commands
What does commands and generates query plan mean?
Thrashing when OS spends more time swapping pages between memory and disk than executing processes.
This happens when the degree of multiprogramming, or the number of processes in memory, exceeds the available memory space
Throughput average # of units actually being processed
Relational Query Processor
Plan Executor Using general-purpose ops (join, sort, select) to make calls to storage manager for data access
Transactional Storage Manager
How does the Transactional Storage Manager Eff read/modify data indexes, table formats, buffering and careful use of storage media
How does the Transactional Storage Manager guarantee data integrity
Connection Manager Ships the generated results back
How do different DBMSs differ