Page 276 - Computer - 10(A&B)

• Create another table named “Orders” including the following fields: OrderId, OrderDate, CustomerId and
OrderAmount.
• Set OrderID as the Primary Key and save the table as Orders.
• Use the field CustomerID to create a relationship between the tables ‘Customers’ and ‘Orders’ using the
Relationships option under the Tools menu.

• Ensure that Enforce Referential integrity is checked in the Edit Relationship dialog box.
• Enter a few records in each table.
• Try to enter an order in the Orders table with a CustomerID that does not exist in the Customers table. You
should receive an error due to referential integrity enforcement.
• Save your work.

Project 2
Create a “Library” database in LibreOffice Base to manage records of books present in the library, list of
members of the library, and record of issue and return of books. The database should contain three tables with
the following structure:
Table: Books Table: Members

Table: Issue&Return

158