23° 22° ночью
66.16 77.68

Форум

В теме 1 сообщение

Help with creating a database for auto repair

Автор hawrd strack, 18 июня 12:33
на форуме 6-й месяц

HI,

As the name implies, I have an auto repair shop and I'd like some pointers on how to set up a database for keeping track of customers and their info (names, addresses, numbers, vehicles, etc.), parts purchasing, invoicing, etc. I've learned quite a bit from sheepdog's website regarding the basics of databases, but I'm not sure exactly where to start with my project.Among other things, here's what I want from an invoice:I want to input a vehicle's year of manufacture, then I want to select a manufacturer from a dropdown list, then I want a dropdown list containing only those models available in that year, from that manufacturer.I have lists of both manufacturers and models already.What I need to know is: do I combine them into one table or would it be wise to have one table for 'make' and one table for 'model' ?Why go with one table instead of two, or visa-versa?I'm fairly computer literate, though I'm new to databases.

Any help will be apprecited.

I didn't find the right solution from the Internet.

References:
https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=66087
Cloud Overview Video

Thank you.

Смотрите также

Вход

Нет аккаунта? Зарегистрируйтесь!