Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) 1. When en entity inatince may be a member of muleiple rubtypes or it doet not have wo be s member of a subtype,

image text in transcribed
1) 1. When en entity inatince may be a member of muleiple rubtypes or it doet not have wo be s member of a subtype, it is which of the following? 2. Overixp with total specialization b. Overipp with partial specialization c. Disjoint with total specialization 2) A functional dependency is a relationthip between or amoog 2. Entities: b. Tables c. Atributes d. Rowr 3) If ooe attribute is deteminant of secood, which in turn is determinant of tiris, then the relation (wellstructured table) cannot be in a. 3rd Normal Form b. 2nd Normal Fonm c. Ist Normal Form 4) If we do not apply normalization, then it will resalt in a. Insertion anamolies b. Updation anamolies c. Deletion anomalies d. All of the mentioned 5) By normalizing relations or sets of relations, one minimizes a. Database b. Redundancy c. Fields d. Data 6) 2NF relations are those that are in INF with all the attribute types dependent on the key. a. Foreign b. Primary c. Composite 7) is the process of defining a set of subelasses of an entity type. a. Expansion b. Generalization c. Specialization d. Division 8) Super classes and subclasses are shown as in EIER diagrams a. Rectangles 6. lines: c. diamond d. ovals 9) Which of the followiog evrocity defires inheritance in EER diagrams? c. When a subtype catily nuberia qethes of the supertype attribute 10) When an entity instance must be a meraber of only one subtype, it is which of the following? a. Disjoint with partial specialization b. Disjoint with total specialization c. Overlap with partial specialization d. Overlap with total specialization

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Knowledge Discovery In Databases

Authors: Gregory Piatetsky-Shapiro, William Frawley

1st Edition

0262660709, 978-0262660709

More Books

Students also viewed these Databases questions

Question

Write down the circumstances in which you led.

Answered: 1 week ago