Crowdly
Add to Chrome
Check the relation(s) that are not in 1NF. 1. Machines(ID_Machine, Machine_Na...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Check the relation(s) that are not in 1NF.
1. Machines(ID_Machine, Machine_Name, Type, Manufacturer)Example: Machines(1, 'CNC Lathe', 'Machining', 'Haas')
2. Products(ID_Product, Product_Name, Category, Unit_Price)Example: Products('P001', 'Ball Bearing', 'Components', 50)
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)Example: Orders('C001', '2025-02-01', 'Ball Bearing, Stainless Steel Screws', '10, 50')
Be careful errors will be penalized.
✅
✅
❌
❌