Question

Database Development
Assume that your own a bicycle store and deal in bicycles for the following categories: Girl kids,
Boy kids, Girl Teens, Boy Teens, Ladies, Gents.
Create a database to store the stock details of the bicycles in your shop for the months of January
and February as: Bicycle category, month, quantity sold, quantity in stock, sale value. Create a
report grouped on the basis of months showing all the details about bicyles.
Write queries to display:
1. Details of all the bicycles sorted on the basis of categories.
2. Details of all the Ladies and Gents bicycles sorted in the basis of month.
3. Increase the stock and quantity sold bu 5% for Girl Teens bicycles.​

Answer 1

Answer:

Database application development is the process of obtaining real-world requirements, analyzing requirements, designing the data and functions of the system, and then implementing the operations in the system.