Which of the following relationships does not respect the 3rd normal form (3NF)?

1. Employees(Employee_ID, Department_ID, Employee_Name,  Department_Name)

2. Projects(Project_ID, Project_Name, Project_Manager)

3. Assignments(Employee_ID, Project_ID, Hours_Worked)

4. Suppliers(Supplier_ID, Supplier_Name, Country)

Indicate which sentence corresponds to the Entity-Association diagram above.

Indicate which sentence corresponds to the Entity-Association diagram above.

Which of the following SQL queries is correct for inserting a new record into the Products table with the columns Product_ID, Product_Name and Price?

Check the relation(s) that are not in 1NF.

1. Machines(ID_Machine, Machine_Name, Type, Manufacturer)

2. Products(ID_Product, Product_Name, Category, Unit_Price)

3. Stocks(Warehouse_ID, Warehouse_Name, Available_Products)

Example: Stocks('E001', 'Warehouse A', 'Ball Bearing, Stainless Steel Screws')

4. Orders(Order_ID, Date, Ordered_Products, Quantities)

Be careful errors will be penalized.

Assuming that the field "supplierAddress" is non-decomposable.

ARTICLE1 (idArticle, articleName, supplierName, supplierAddress)

ARTICLE2 (articleName, supplierName, supplierAddress)

Indicate which of these statements is true:

Los cormófitos (Helechos,

gimnospermas y angiospermas) son plantas vasculares. Indique un carácter sinapomórfico que los defina como grupo y un carácter apomórfico que delimite el conjunto de

gimnospermas y angiospermas frente a los helechos.