Create an Entity-Relationship Diagram for Students, Subjects, and LabRoom tables and write a query for product information.

Here are the solutions to the questions:

8. Relationship Diagram
Assuming question 8 refers to the database tables and relationships created in the previous task (Students, Subjects, LabRoom tables with StudentID, SubjectID, SectionID as primary keys and foreign keys), here is a conceptual Entity-Relationship Diagram (ERD):

+-----------------+       +-----------------+       +-----------------+
|     Students    |       |     Subjects    |       |     LabRoom     |
+-----------------+       +-----------------+       +-----------------+
| *StudentID (PK)*|----<  | *SubjectID (PK)*|       | *SectionID (PK)*|
| FirstName       |       | SubjectName     |       | LabRoomName     |
| LastName        |       +-----------------+       +-----------------+
| Gender          |
| SubjectID (FK)  |----------------------------------^
| SectionID (FK)  |--------------------------------------------^
+-----------------+

• Students table has StudentID as its primary key.
• Subjects table has SubjectID as its primary key.
• LabRoom table has SectionID as its primary key.
• A one-to-many relationship exists between Subjects and Students (one subject can have many students).
• A one-to-many relationship exists between LabRoom and Students (one lab room/section can have many students).

9. Query for Product Information

To create a query that displays productID, productName, and unitCost where unitCost is '100', you would use the following SQL (or steps in a database query design tool like MS Access):

• SQL Query:

  SELECT productID, productName, unitCost
  FROM Products
  WHERE unitCost = 100;
  

  Copy
• MS Access Query Design Steps:
  1. Go to the "Create" tab and select "Query Design".
  2. Add the Products table to the query.
  3. Drag the productID, productName, and unitCost fields to the design grid.
  4. In the "Criteria" row for the unitCost field, type 100.
  5. Run the query to see the results.
  6. Save the query with a descriptive name (e.g., ProductsWithUnitCost100).

TASK 2 (Programming)

Here is the Pascal code to implement the given algorithm:

Program Practici;
Var
  i, n, Snum, product, counter: INTEGER;
Begin
  Write('Enter three integers (i, n, Snum): ');
  ReadLn(i, n, Snum);

  product := i;
  counter := 1;

  WHILE counter <= n DO
  BEGIN
    product := product * Snum;
    counter := counter + 1;
  END;

  WriteLn('The product is: ', product);
End.