databases Online Quiz - 33
| Description: databases Online Quiz - 33 | |
| Number of Questions: 20 | |
| Created by: Aliensbrain Bot | |
| Tags: databases |
What is a 'tuple' ?
A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes:
A company has a model consisting of eight entities. The parent entity, "Company," has three child entities: "Employee," "Product," and "Order." The Product entity has a categorization of four entities: "Computer," "Software," "Accessory," and "Clearance." Each entity has only one attribute making up the key attribute. Based on the scenario above, what foreign key appears in the model exactly three times ?
Several pieces of information are captured about a book. This information includes: Title, Author First Name, Author Last Name, Book Genre, and Date Published. Based on the scenario above, what part of the entity relationship is the Title?
Most RDB designers will accept that in order to deal with the complexities of "real life" transactions, a design needs to reach
Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:
Data Modeling:
create table Purchaser{ name string, credit_card integer (primary key), address string } create table Product{ product_id integer (primary key), product_name string } create table Purchaser_Product{ credit_card integer, product_id integer, purchase_date date } Based on the sample code above, what is the primary key in the Purchaser_Product table?
What is an alternate key?
A Banking and Financial Customer is interested to have an overview of a transactional data of their systems. Which of the following data model is suitable to fulfill the customer requirements?
If a key from a parent entity migrates into the primary key of the child entity, what type of relationship is formed?
What can a mandatory one to one relationship indicate?