Upgrade to remove ads
SQL Exam "study" chapter 2 2018
Terms in this set (20)
In a chen ER model a relationship is represented by:
A way of classifying data models is by degree of _________
If a painter paints many paintings and one painting is painted by one painter - what relationship is this:
What is the fastest and most direct source of business rules?
interviews with end users
In a Crow's foot notation diagram the crows foot shows:
A connection to the entity on the many side of the relationship
The _______ model adapts a conceptual model to a specific DBMS
Which model shows a series of 1:M relationships which each parent can have many children, but each child has only one parent.
the hierarchical model
What modern development has drastically changed the role and scope of the database market?
If classes are attended by many students and each student can attend many classes the relationship is
The most widely used conceptual model is the _______ model.
If a person manages one department and a department is managed by one person this relationship is:
Data models were developed to ____________
model real-world events or conditions
Which model requires the definition of physical storage and data access methods:
The basic building blocks of all data models are entities, attributes, relationships and ___________
An association between entities is a
A relational database is a collection of _________
The ERDM is primarily geared to business applications, while the OODM tends to focus on ____ applications
very specialized engineering and scientific
In a chen model an entity is represented by:
In a basic Crow's foot ERD the three-pronged symbol is used to represent
the many side of a relationship
The _____________ model is the relational mode's challenge to the OODM.
YOU MIGHT ALSO LIKE...
Database Systems Ch.2
OTHER SETS BY THIS CREATOR
CCNA 4 Final study
WH&S 1 quiz
WH&S 2 quiz
WH&S 3 quiz