Test
Database and SQL
Preguntas del test (2)
1SCENARIO: 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.- Aa parts table, a cycle table, and an accessories table
- Bone table for all parts, cycles, and accessories
- Ca table for each part, each cycle, and each type of accessory (a helmet table, a biking glove table, and so on)
2SCENARIO: 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.- Apart number, part name, cycle number, and cycle name
- Bpart number and quantity sold
- Cpart number, part name, quantity, color, and cycle identifier
- Apart number, part name, cycle number, and cycle name
Información
- Descripción
- Database and SQL
- Autor
- Jos Bleeker
- Idioma
- English
- Visitas
- 131
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test