Proiectarea Bazelor De Date

1. Unele atribute trebuie neaparat sa aiba valoare. Acestea se numesc :

mandatorii (obligatorii)

optionale

Some attributes must have a value, and these are called "mandatorii" or "obligatorii" (mandatory or obligatory).

Explanation

Some attributes must have a value, and these are called "mandatorii" or "obligatorii" (mandatory or obligatory).

2. Care dintre urmatoarele variante nu poate reprezenta un atribut al entitatii ELEV :

nume

adresa

consum

prenume

The attribute "consum" cannot represent an attribute of the entity "ELEV" because "consum" does not seem to be a characteristic or property that is typically associated with a student. Attributes like "nume" (name), "adresa" (address), and "prenume" (first name) are more commonly associated with a student entity. However, "consum" does not provide any relevant information about a student and does not fit the context of the entity "ELEV".

Explanation

The attribute "consum" cannot represent an attribute of the entity "ELEV" because "consum" does not seem to be a characteristic or property that is typically associated with a student. Attributes like "nume" (name), "adresa" (address), and "prenume" (first name) are more commonly associated with a student entity. However, "consum" does not provide any relevant information about a student and does not fit the context of the entity "ELEV".

3. Ce semnificatie are "piciorul de cioara" in cadrul unui ERD?

relatia este obligatorie

relatia este optionala

pot exista una sau mai multe instante ale entitatii langa care apare semnul in relatie cu o instanta a celeilalte entitati

niciuna din variantele anterioare

The "piciorul de cioara" symbol in an ERD indicates that there can be one or more instances of an entity next to which the symbol appears in relation to an instance of the other entity. This means that the relationship between the entities is one-to-many, where one instance of the first entity can be associated with multiple instances of the second entity.

Explanation

The "piciorul de cioara" symbol in an ERD indicates that there can be one or more instances of an entity next to which the symbol appears in relation to an instance of the other entity. This means that the relationship between the entities is one-to-many, where one instance of the first entity can be associated with multiple instances of the second entity.

4. O entitate este de obicei :

un verb

substantiv

un adverb

orice cuvant

An entity is typically a noun. Nouns are words that represent a person, place, thing, or idea. In this context, an entity refers to something that exists or can be identified. Verbs, adverbs, and any other word types do not typically represent entities in the same way that nouns do. Therefore, the correct answer is substantiv.

Explanation

An entity is typically a noun. Nouns are words that represent a person, place, thing, or idea. In this context, an entity refers to something that exists or can be identified. Verbs, adverbs, and any other word types do not typically represent entities in the same way that nouns do. Therefore, the correct answer is substantiv.

5. Cum se citeste corect relatia dintre CLIENT si MASINA?

Fiecare CLIENT poate sa inchirieze o MASINA si numai una.

Fiecare CLIENT trebuie sa inchirieze o MASINA si numai una.

Fiecare CLIENT poate sa inchirieze una sau mai multe MASINI.

Fiecare CLIENT trebuie sa inchirieze una sau mai multe MASINI.

Each CLIENT can rent one or more CARS.

Explanation

Each CLIENT can rent one or more CARS.

6. Asociati atributele din lista, corespunzatoare entitatilor :

CLIENT

MASINA

COMANDA

JOB

AFACERE

ANGAJAT

Submit

7. Care dintre urmatoarele fraze poate fi citita din schema alaturata:

Un student poate sa urmeze mai multe cursuri

Un curs poate fi urmat de mai multi studenti.

Un student trebuie sa urmeze un singur curs.

Un curs trebuie sa fie urmat de un student.

The given answer, "Un curs poate fi urmat de mai multi studenti," can be inferred from the diagram because it states that a course can be taken by multiple students. This is supported by the arrows connecting the "Curs" node to multiple "Student" nodes in the diagram.

Explanation

The given answer, "Un curs poate fi urmat de mai multi studenti," can be inferred from the diagram because it states that a course can be taken by multiple students. This is supported by the arrows connecting the "Curs" node to multiple "Student" nodes in the diagram.

8. Relatia:

Reprezinta ceva semnificativ pentru afacere

Exprima care sunt legaturile intre doua entitati (sau intre una si aceeasi entitate).

Se citeste in ambele sensuri

Are optionalitate

Toate celelalte variante

Are un grad de cardinalitate

not-available-via-ai

Explanation

not-available-via-ai

9. Atributul este: (alegeti variantele corecte)

Este o proprietate a unei entitati sau un detaliu referitor la acesta.

Descrie, cuantifica, califica, clasifica sau specifica o entitate

Are un tip care poate fi un numar, un sir de caractere, o data calendaristica, o imagine, etc.

The correct answer includes three statements that describe the attribute. First, an attribute is a property or detail related to an entity. Second, it describes, quantifies, qualifies, classifies, or specifies an entity. Third, it has a type that can be a number, a string of characters, a calendar date, an image, etc. These statements collectively define what an attribute is and its characteristics.

Explanation

The correct answer includes three statements that describe the attribute. First, an attribute is a property or detail related to an entity. Second, it describes, quantifies, qualifies, classifies, or specifies an entity. Third, it has a type that can be a number, a string of characters, a calendar date, an image, etc. These statements collectively define what an attribute is and its characteristics.

Submit