Tag: technology

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business, rather than from any specific information requirements in screens, reports, or business forms, is referred to as the:

A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes a(n):

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 ?

If a key from a parent entity migrates into the primary key of the child entity, what type of relationship is formed?