Tag: architecture
Questions Related to architecture
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 ?