Make known the following:- General objective- Specific objectives- Breakdown of activities- Justification and contribution:What is the research for?Who benefits from the results?Does it help solve any practical problems?Does it contribute to increasing knowledge?Can the results be generalized?- ViabilityCan this research be carried out?How long will it take to do it?- Planning of the following statement:   Personnel are required to register their name, name, surname, date of birth, address, pension, telephone number. and institutional mail. The client is interested in knowing his name, name, address, business, telephone, email, date of birth. Each person can only have one telephone number, one address, one forecast and one email. Work Orders must be registered in the system, which record the date and number. Each order is associated with a single vehicle and a single customer. The cause(s) of the breakdown must be established: Accident Address Alarm Bodywork Electric Clutch On Brakes Tires Engine Battery Fluids Straps When registering a vehicle, it is required to store its license plate, make, model, transmission, displacement, type. (only one), color, year, VIN, engine, chassis, country of origin, fuel type. The types of vehicles are: City car.SUV.Minivan.Minibuses. Hatchback.Crossover.Cargo vans.Buses. Sedan.Station wagon.Vans.Trucks. Coupé.Van.Minivan.Motorcycles. When vehicles are entered into the workshop, they may have one or more damages, which must be identified. and where in the vehicle they are located, which can be none or many places. Damage is categorized by: Failure Dented Scrape The places can be: Front ◦ Left/right focus ◦ Bumper ◦ Capo ◦ Window ◦ Left/right fog light ◦ Patent Superior ◦ Roof ◦ Window ◦ Antenna ◦ Luggage rack Rear ◦ Left/right focus ◦ Bumper ◦ Door ◦ Window ◦ Left/right mirror ◦ Left/right fog light ◦ Patent Left or Right Side ◦ Left/right fender ◦ Front/rear door ◦ Front/rear tire ◦ Front/rear handle ◦ Flashing The amount of fuel available and mileage must also be identified at the time of entry. On the other hand, it must be recorded if the vehicle has some components. Internal Mirror Parasol Lighter Radio Safety Belt dad Rubber Floor Speakers Ashtray Console emblems Exterior Mirror Windshield Wiper fog lights Antenna Left Front Wheel darling Wheel Lead Right Left Rear Wheel darling Rear Wheel right Wheel Cover Benzine Cap Battery Radiator Cover Triangle Cat Spare wheel Extinguisher Kit Key A customer can enter many vehicles, but each vehicle can only be associating one customer per once and to a single work order. The company sells vehicle parts and pieces, each one has an associated code, number of piece, name, brand, category, description and quantity. Each part is related to a make and year of vehicle. Each part/piece has a price that may change over time. The stock of each part/piece must be known. At the same time, it must be possible to provide a budget for the repairs that involve determining the spare parts. (they may be in stock or not), the quantity, value and detail. On the other hand, the company can generate quotes, the quotes may or may not be linked to a work order. Quotes must have a date, associated invoice, days of validity, quote number, customer information, mechanic in charge, item or labor code, description, quantity, unit price and total price. Every work order or quote must indicate the value of labor, total spare parts, discount, net value, VAT, in addition to the total, any observations, mechanic in charge and invoice code associated. Likewise, the company needs inventory control that allows knowing all the equipment that has in the workshop. It must be registered with a code, name, brand, year, location and purchase amount.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Make known the following:
- General objective
- Specific objectives
- Breakdown of activities
- Justification and contribution:
What is the research for?
Who benefits from the results?
Does it help solve any practical problems?
Does it contribute to increasing knowledge?
Can the results be generalized?
- Viability
Can this research be carried out?
How long will it take to do it?
- Planning

of the following statement:

 

  1. Personnel are required to register their name, name, surname, date of birth, address, pension, telephone number.

and institutional mail.

  1. The client is interested in knowing his name, name, address, business, telephone, email, date of birth.
  2. Each person can only have one telephone number, one address, one forecast and one email.
  3. Work Orders must be registered in the system, which record the date and number.
  4. Each order is associated with a single vehicle and a single customer.
  5. The cause(s) of the breakdown must be established:

Accident

Address

Alarm

Bodywork

Electric

Clutch

On

Brakes

Tires

Engine

Battery

Fluids

Straps

  1. When registering a vehicle, it is required to store its license plate, make, model, transmission, displacement, type.

(only one), color, year, VIN, engine, chassis, country of origin, fuel type.

  1. The types of vehicles are:

City car.SUV.Minivan.Minibuses.

Hatchback.Crossover.Cargo vans.Buses.

Sedan.Station wagon.Vans.Trucks.

Coupé.Van.Minivan.Motorcycles.

  1. When vehicles are entered into the workshop, they may have one or more damages, which must be identified.

and where in the vehicle they are located, which can be none or many places.

Damage is categorized by:

  • Failure
  • Dented
  • Scrape

The places can be:

  • Front

◦ Left/right focus

◦ Bumper

◦ Capo

◦ Window

◦ Left/right fog light

◦ Patent

  • Superior

◦ Roof

◦ Window

◦ Antenna

◦ Luggage rack

  • Rear

◦ Left/right focus

◦ Bumper

◦ Door

◦ Window

◦ Left/right mirror

◦ Left/right fog light

◦ Patent

  • Left or Right Side

◦ Left/right fender

◦ Front/rear door

◦ Front/rear tire

◦ Front/rear handle

◦ Flashing

  1. The amount of fuel available and mileage must also be identified at the time of entry.
  2. On the other hand, it must be recorded if the vehicle has some components.

Internal Mirror

Parasol

Lighter

Radio

Safety Belt

dad

Rubber Floor

Speakers

Ashtray

Console

emblems

Exterior Mirror

Windshield Wiper

fog lights

Antenna

Left Front Wheel

darling

Wheel

Lead

Right

Left Rear Wheel

darling

Rear Wheel

right

Wheel Cover

Benzine Cap

Battery

Radiator Cover

Triangle

Cat

Spare wheel

Extinguisher

Kit

Key

  1. A customer can enter many vehicles, but each vehicle can only be associating one customer per

once and to a single work order.

  1. The company sells vehicle parts and pieces, each one has an associated code, number of

piece, name, brand, category, description and quantity.

  1. Each part is related to a make and year of vehicle.
  2. Each part/piece has a price that may change over time.
  3. The stock of each part/piece must be known.
  4. At the same time, it must be possible to provide a budget for the repairs that involve determining the spare parts.

(they may be in stock or not), the quantity, value and detail.

  1. On the other hand, the company can generate quotes, the quotes may or may not be linked to a

work order.

  1. Quotes must have a date, associated invoice, days of validity, quote number, customer information,

mechanic in charge, item or labor code, description, quantity, unit price and total price.

  1. Every work order or quote must indicate the value of labor, total spare parts,

discount, net value, VAT, in addition to the total, any observations, mechanic in charge and invoice code

associated.

  1. Likewise, the company needs inventory control that allows knowing all the equipment that

has in the workshop. It must be registered with a code, name, brand, year, location and purchase amount.

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Decision Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education