Database and SQL

Jos Bleeker
Quiz by Jos Bleeker, updated more than 1 year ago
Jos Bleeker
Created by Jos Bleeker about 6 years ago
58
0

Description

Database and SQL

Resource summary

Question 1

Question
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.
Answer
  • 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)

Question 2

Question
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.
Answer
  • part number, part name, cycle number, and cycle name
  • part number and quantity sold
  • part number, part name, quantity, color, and cycle identifier
Show full summary Hide full summary

Similar

SQL Quiz
R M
SQL Quiz
Chris Cronin
Midterm 2 (Chapter 5 - 13)
Yorria Raine
Database Final Exam
dbm
Coding Quiz
ryanseaborne
Microsoft Virtual Academy - SQL Server Basics
chrisburford
Databases
Alex Baine
SQL SERVER flashcards
Thomas Gooch
SQL Server
Jordan Cartwright
INTRODUCCION A BASE DE DATOS
Jose Vicente