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
A wide range of topics related to database concepts and modeling, including data models, relationships, keys, normalization, and design patterns. It provides detailed explanations and examples for various database concepts, such as first-generation data models, logical independence, metadata, distributed data, schemas, referential integrity, composite entities, natural keys, transitive dependencies, and more. The document also touches on object-oriented concepts like classes, inheritance, and abstraction. Overall, this document serves as a comprehensive guide to understanding the fundamental principles and techniques of database design and management.
Typology: Exams
1 / 9
This page cannot be seen from the preview
Don't miss anything!
This is data that exist in their original (raw) state, ie. the format in which they were collected. - answer ✅✅Unstructured Which generation of data model was used mainly on IBM mainframes and managed records, not relationships? - answer ✅✅First When you can change the internal model without affecting the conceptual model, you have - answer ✅✅Logical independence
is a logically connected set of one or more fields that describes a person, place or thing. - answer ✅✅record The M:N relationship specifies that there is a ______to ______ relationship between entities. - answer ✅✅Many, Many Students in COP3703, and the teacher is an example of this type of relationship. - answer ✅✅1:M The length of a specific data field or its format (char, vchar, num, etc.) is an exame of this type of data. - answer ✅✅Metadata Which ONE of the following DBMS systems does not permit distributed data? - answer ✅✅MS Access The ________ is the conceptual organization of the entire database as viewed by the database administrator. - answer ✅✅Schema
This type of attribute may be calculated from other attributes - answer ✅✅Derived A _______ relationship between entities exists if the primary key of the related entity does not contain the primary key component of the parent entity. - answer ✅✅weak You are designing a new database and need to create an Entity Relationship Diagram. Two of the entities are employees and benefits. What is this type of relationship - answer ✅✅M:N Jennifer is updating the database for her company. She wants to delete customer records that have not made a purchase from more than 5 years ago but when she tries the database tells her that she can't because she must first delete the customer sales transactions records first. What is this referred to? - answer ✅✅Referential Integrity When you set up an Entity Relationship Diagram, and have a many-to-many relationship, this entity
is created to avoid problems inherent to a many-to- many relationship. - answer ✅✅Composite entity __________ is a real-world identifier used to uniquely identify real-world objects. - answer ✅✅Natural key This is a "virtual" entity type used to represent multiple entities and relationships in the ERD. - answer ✅✅Entity Cluster When would you use a composite primary key? - answer ✅✅M:N relationship? The entity "cars" would be this type of entity if another entity called "vehicles" existed in an ER- Diagram. - answer ✅✅subtype? What is the first step in normalizing a table/entity?
Business intelligence - answer ✅✅Captures and processes business data to generate information that support decision making. Structural independence - answer ✅✅File structure is changed without affecting the application's ability to access the data Data anomaly - answer ✅✅Develops when not all of the required changes in the redundant data are made successfully. Object - answer ✅✅Contains data and their relationships with operations that are performed on it. The basic building block for autonomous structures. Abstraction of real-world entity. Class - answer ✅✅Collection of similar objects with shared structure and behavior organized in a class hierarchy. Class hierarchy - answer ✅✅Resembles an upside- down tree in which each class has only one parent
Inheritence - answer ✅✅Objects inherits methods and attributes of parent class. Physical independence - answer ✅✅Changes in physical model do not affect internal model. Functional dependence - answer ✅✅Value of one or more attributes determines the value of one or more other attributes. Full functional dependence - answer ✅✅Entire collection of attributes in the determinant is necessary for the relationship. Entity Integrity - answer ✅✅Condition in which each row in the table has its own unique identity. Inner join - answer ✅✅Only returns matched records from the tables that are being joined Outer join - answer ✅✅Matched pairs are retained and unmatched values in the other table are left null
