Create an account
Columns that belong to a different table than the one in which they reside are called ______.
Which of the following is false regarding the process of creating the database?
database developers use metadata to create tables, relationships, and other structures in the database
The functions of a DBMS include all of the following except ______.
performing memory swapping to across the database
A ______ is a collection of forms, reports, queries, and programs that process a database.
Brenda wants to find a particular report containing sales analysis of the second and third quarter. After accessing the DBMS, she should type in the keyword into a _____ form to locate what she is looking for.
Which of the following is not part of the database development process?
an external verification agency validates the data model
Which of the following statements is true about entities?
an entity is something that the users want to track
What are crow's feet?
shorthand for multiple lines showing relations between two entities in an E-R diagram
Which of the following is true of N:M relationships?
more than one entity is allowed on each side of the relationship
In an entity-relationship diagram, a line between two rectangles represents a(n) ______.
In an entity-relationship diagram, a _____ on a line means that at least one entity type of that type is required.
If a student is allowed to have multiple majors and advisers are assigned to multiple students, this would be an example of a ______ relationship.
_____ is the process of converting a data model into tables, relationships, and data constraints.
The database design team transforms entities into tables and expresses relationships by defining ______.
______ is the process of converting a poorly structured table into two or more well-structured tables.
If the same data element is stored differently in another table, this is said to be an issue of ______.
Which of the following statements about normalization is false?
normal forms are tables classified according to the problems
All the following steps involved in transforming a data model into a relational database design except _____.
each attribute of the entity becomes a row of the table
When transforming a data model into a database design, designers represent relationships by ______.
using the entity identifier
Which of the following is true of the database development process?
changing a relationship from 1:N to N:M is simply a matter of changing the notations
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together