architecture Online Quiz - 1
Description: architecture Online Quiz - 1 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: architecture |
Database modelling:
Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:
Which of the following is not a data modeling tool?
What is the goal of Data Architecture
Data architecture document dos not include:
What is an alternate key?
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?
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 ?
What is a schema?
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?