Question Title: Practical Database Applications
- How can form properties be manipulated to restrict data entry in a database?
- Design a query to find students who are over 15 years old and have a grade above 80.
- How can you customize a report in the Report Wizard to group data by a specific field?
- How would you use a database to manage a small store’s inventory, including tables, forms, queries, and reports?
- How does the feature of “integrity” in databases prevent data issues, and how can it be enforced in a DBMS?
Ruwan Suraweera Changed status to publish
Answers and Descriptions:
- Answer: Set properties like “read-only” or “maximum length” to limit what users can enter or edit in a form.
Description: A “Grade” field can be set to accept only numbers between 0-100, preventing invalid entries like “ABC.” - Answer: Use criteria “Age > 15” AND “Grade > 80” in the query tool, sorting by name.
Description: This filters the database to show only high-performing older students, useful for identifying scholarship candidates. - Answer: In the wizard, select “Group By” and choose a field (e.g., “Class”) to organize data into sections.
Description: Grouping by “Class” in a student report separates results by classroom, making it easier to analyze class performance. - Answer: Create a “Products” table (Product ID, Name, Stock) and a “Sales” table (Sale ID, Product ID, Date). Use forms for stock updates, queries to find low-stock items, and reports for monthly sales.
Description: This system tracks stock levels, identifies reorder needs with queries (e.g., “Stock < 10"), and summarizes sales in reports. - Answer: Integrity ensures data accuracy and consistency (e.g., no duplicate records). It’s enforced in a DBMS with primary keys and relationship rules.
Description: A primary key like “Order ID” prevents duplicate orders, and linking tables ensures a sale references a valid product, avoiding errors.
Ruwan Suraweera Changed status to publish