Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
29 Cards in this Set
- Front
- Back
What is a database? |
A database is collection of persistent data that models the world as a shared resource. |
|
What is a DBMS? |
DBMS(Database management system) is software that is specialized in handling large pieces of data and managing it by providing retrieval and persistence. |
|
What is the purpose of a DBMS? |
It handles all the interactions with the database. it provides easy access using a declarative query language. It checks for constraints which saves programmer time. It ensures data independence. it offers concurrent access and automatic recovery from updates. Finally it offers security by restricting access to just specific users. |
|
What three levels of abstraction does the database system use to hide details from users? |
the physical level: how the data is stored the logical level: based on a data model the view level: what programs of the user sees. |
|
How does the level of abstractions ensure data independence? |
it offers physical data independence, i.e. that the physical level may be changed without affecting the logical level. |
|
What is an instance in the context of a database. |
An instance is a collection of data at a given time within the database. |
|
What is the schema of a database? |
The schema is the overall design of the database. There are schemas for each level abstraction of the database. schemas at the view level are sometimes called sub schemas. |
|
What are disadvantages of using a specific DBMS? |
Your data is locked into one solution. it can be costly to maintain in both space and time. |
|
give examples of common end users of DBMS? |
Database administrators, end users, application programmers and enterprise administrator who is responsible for database design. |
|
Describe the three parts of a data model |
the structural part: the integrity part: the manipulative part: declarative or procedural. |
|
How does the relational model map to the generic datamodel? |
the structural part: relations the integrity part: keys and foreign keys the manipulative part: SQL or query language. |
|
Why do we look into the entity relation model? |
It is an example of a highlevel database model. it helps us design before moving to a lower level model. |
|
What are alternatives to the entity relation model? |
UML |
|
name the components of the structural part of the entity model |
entity types, attributes, relationship types |
|
What are the integrity constraints of the entity model? |
primary keys for entity types and relationship types. |
|
Why is the ER model only considered a partial data model? |
it has no standard manipulative part. |
|
State some advantages of the ER model |
it is relatively simple, it is user friendly and it provides a unified view unlike any implemented data model. |
|
what are the main building blocks of the an ERD? |
entities and entity types, relationships and relationship types, attributes, attribute values and domains. |
|
Describe and entity. |
an entity is a "thing" that can be uniquely identified. An entity type is a collection of similar entities, which is similar to a class in object oriented languages. |
|
what do attributes represent on entities |
they represent properties of entities |
|
How are entities represented in an ERD diagram? |
by a rectangle. |
|
how are attributes represented in an ERD? |
they are represented by an oval. |
|
Can attributes have multiple values in ERDs? |
yes, these are normally represented by a double oval. |
|
What is a domain in an ERD diagram? |
a domain of an attribute is the set of constant values that can be associated with an attribute. |
|
What is an atomic domain in ERDs? |
integers for instance |
|
what is a set valued domain in ERDs? |
finite sets. |
|
What are relationship types? |
A relationship type is an association between two or more entities. |
|
how are relationship types represented in an ERD? |
using a diamond shape with lines to to each of the entities involved. |
|
What is a relationship in an ERD? |
a relationship is an instance of a relationship type, i.e. it is a set of associations between entities. |