Hi Guys,
I'm kinda new to mysql and have a question.
Say you have a scenario were you have information that needs to be stored, but in groups.
So I might be running a business that requires me to keep track of hair appointments.
Each appointment is a job.
Every job could have multiple services.
every service could have multiple products associated with it.
I would like to make it so that the mysql table could store multiple instances of products in a service and multiple services in a job.
Can this be done? Any advice would be much appreciated!
5  1806 
Best advice I can give you is to read up on relational database design. We have an introductory article on Database normalisation and table structures in our Access section which is a very good place to start.
-Stewart
Thank you stewart, i'll check it out!
Stewart, thanks again for the guide, that was helpful. I still have a question if you dont mind:
I have separated my tables in such a manner that has a primary key relating an id per service and then a separate table with it's own id based on products available.
For simplicity:
Services
S_id Name
0 hair cut
1 color hair
2 trim eyebrows
Products
P_id Name
0 hair color brown
1 Toe nail clippers
2 shampoo
How would these tables then be combined into a single table to show a single invoice?
That tracks an invoice id(single), the services used (multiple), and Products used (multiple).
Tables themselves do not get combined at all; the whole purpose of relational design is to separate out related entities, not to combine them. Relationships between these tables are defined and set so that the one-to-many relations, in particular, are known and resolved. This is the thrust of the article I suggested you read.
There are occasions when you need to define a linking table to resolve many-to-many relationships (decomposed into two one-to-many relationships), but I don't think that is what you are asking here.
When you need to combine tables together to produce invoices etc this is done by devising a suitable query on the joined tables. The base query has the effect of providing you with a logical view of the data that does not reflect the way the data is stored. The table structure, if properly designed, is free from the potential for update and other anomalies that will always result from implementing un-normalised relationships.
A report can be based on an invoice query so that you can print a suitable invoice for the customer, for example.
I would urge you to explore relational design in depth before you move on - it takes much practice to get it right. Get yourself a good introductory book and work through the exercises - there is no substitute for this, as you will only learn how to normalise data by implementing real examples.
-Stewart
Thank you stewart, that was very helpful!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: James |
last post by:
I have a from with 2 fields:
Company & Name
Depening which is completed, one of the following queries will be run:
if($Company){
$query = "Select C*
From tblsample
Where ID = $Company
Order By Company ASC";
|
by: Scott D |
last post by:
I am trying to check and see if a field is posted or not, if not
posted then assign $location which is a session variable to
$location_other. If it is posted then just assign it to
$location_other
I keep getting "Notice: Undefined index: location_other" referring to
(!($_POST)) {
$location_other = $location;
}
else
|
by: Nick |
last post by:
Can someone please tell me how to access elements from a multiple
selection list? From what ive read on other posts, this is correct. I
keep getting an "Undefined variable" error though...
Form page************************************************************
<form action="/process.php" method="get" name="formOne" id="formOne">
<select name="owner" size="6" multiple id="owner">
<option value="one">one</option>
<option...
|
by: Alexander Ross |
last post by:
I have a variable ($x) that can have 50 different (string) values. I want
to check for 7 of those values and do something based on it ... as I see it
I have 2 options:
1) if (($x=="one") || ($x=="two") || ... || ($x=="seven")) ...
or
2) switch ($x){
case("one"):
|
by: Dan Foley |
last post by:
This script runs fine, but I'd like to know why it's so slow.. Thanks
for any help out there on how i can make it faster (it might take up
to 5 min to write these 3 export files whith 15 records each!!!)
Dan
====================
<style>
body, table, tr, td {
font-family: 'verdana';
font-size: 12px;
| | |
by: Lee Redeem |
last post by:
Hi there
I've created abd uploaded this basic PHP script:
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<H1 align="center">
|
by: christopher vogt |
last post by:
Hi,
i'm wondering if there is something like $this-> to call a method inside
another method of the same class without using the classname in front.
I actually use
class TEST
{
function func1()
|
by: Phil Powell |
last post by:
Ok guys, here we go again!
SELECT s.nnet_produkt_storrelse_navn
FROM nnet_produkt_storrelse s, nnet_produkt_varegruppe v,
nnet_storrelse_varegruppe_assoc sv, nnet_produkt p
WHERE s.nnet_produkt_storrelse.id = sv.nnet_produkt_storrelse_id
AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id
AND sv.nnet_produkt_varegruppe_id IN (
SELECT nnet_produkt_varegruppe_id
FROM nnet_produkt_varegruppe
|
by: Michel |
last post by:
a site like this
http://www.dvdzone2.com/dvd
Can you make it in PHP and MySQL within 6 weeks?
If so, send me your price
2 a r a (at) p a n d o r a . b e
|
by: Maciej Nadolski |
last post by:
Hi!
I can`t understand what php wants from me:( So:
Cannot send session cache limiter - headers already sent (output started at
/home/krecik/public_html/silnik.php:208) in /home/krecik/public_html/silnik.php on
line 251
Line 208: print ( "error: " . mysql_error());
Line 251: session_register("uprawnienia", "zalogowany");
I can understand that sth, is wrong in line 251 after line 208 and it is logical to
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
