Page 251 - Computer - 10(A&B)

c. display the items whose quantity sold is less than 10.
d. display the items whose quantity sold is more than 50 or whose price is less than 500.
e. display the items whose quantity sold is more than 50 and whose price is less than 500.

Experiential Learning
DIY in the LabIY in the Lab Experiential Learning
D
v Create a database for a music shop to store the list of various music titles available in the shop and to
maintain a list of customers who have purchased music systems from the shop. The fields of these two
tables are to be like this:

Table 1: Products
Fields:
Product ID Title Artist Supplier Rate Quantity available Reorder level

Table 2: Customer
Fields:

Customer ID Name Address Product ID Date of sale Warranty (Y/N)
Select the suitable data type for each field and create tables in Libreoffice Base using the Design view. Also,
select the primary key field in each table and enter at least 20 records in Products table and 10 records in
Customer table.
v Create the tables given below.

Student ID Name Course Start Date Instructor Fees

SD001 Arjun NTSE 01/10/2018 Ram 13,000/-

SD002 Rayan IIT–JEE 25/09/2018 Sangeeta 50,000/-

SD003 Neetika SAT 01/02/2018 Vandana 25,000/-

SD004 Anant SAT 10/02/2018 Vandana 25,000/-

Student ID Father’s Name DOB Address
SD001 Ram Lal 05/01/2004 1/6001, Shahdara

SD002 Anil Kumar 28/09/2004 A-23, Vivek Vihar

SD003 Vimal Jain 19/11/2003 B-366, Shivaji Park

SD004 Mohit Sharma 06/02/2002 C-25, Laxmi Nagar

) State the primary key field in the table.

) Identify the data type of each field in the table.
) Describe the properties which you would like to set for each field in the table.
) Categorise the fields having same properties.
) Create a query to show records with fees more than 25,000.

) Create a query to show records in course IIT-JEE or who pay fees of 25,000.

133