Jos Bleeker
Quiz por , criado more than 1 year ago

Database and SQL

90
0
0
Jos Bleeker
Criado por Jos Bleeker mais de 9 anos atrás
Fechar

Database and SQL

Questão 1 de 2

1

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.

Selecione uma das seguintes:

  • a parts table, a cycle table, and an accessories table

  • one table for all parts, cycles, and accessories

  • a table for each part, each cycle, and each type of accessory (a helmet table, a biking glove table, and so on)

Explicação

Questão 2 de 2

1

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.

Selecione uma das seguintes:

  • part number, part name, cycle number, and cycle name

  • part number and quantity sold

  • part number, part name, quantity, color, and cycle identifier

Explicação