Database and SQL

SCENARIO: High-school student Rajesh M. Patel works part-time in his dad’s cycle shop in Pune, India. Pune was the first city in India to have dedicated lanes for cycles. Raj’s dad currently keeps track of his inventory using pencil and paper. Ordering parts and accessories or counting inventory takes several days. Raj is taking a database management class in school and he realizes that his dad’s business could benefit greatly by implementing a database management system. Raj needs to review a few basic concepts before he starts, and has made a list of topics he knows will be important in the first steps of the project. Question: Identify tables that Raj might create for the database.

SCENARIO: High-school student Rajesh M. Patel works part-time in his dad’s cycle shop in Pune, India. Pune was the first city in India to have dedicated lanes for cycles. Raj’s dad currently keeps track of his inventory using pencil and paper. Ordering parts and accessories or counting inventory takes several days. Raj is taking a database management class in school and he realizes that his dad’s business could benefit greatly by implementing a database management system. Raj needs to review a few basic concepts before he starts, and has made a list of topics he knows will be important in the first steps of the project. Question: Identify the fields that Raj should use for column headings of the parts table.