Alo all,
We are targeting specific kind of customers who use different kind of services such as fashion shops, cosmetics etc. This service providers just buy a package (domain, web site, db etc) and they are good to go. Now they customers are repeated time and again and so a single customer is registered 5-6 times in a single computer running mysql server with database for each service.
I want to have a single customers table and make it avaliable to the business underground. I donno how I would go about it since a customer can be registered (Action queries) and authenticated (fetch queries).
Does my idea make any sense from a development and security point of view? Any idea on how to handle it?
1  1663   zmbd 5,501
Recognized Expert Moderator Expert
In any RDMS you would create a table that holds just the customer information and other tables to hold other information.
Sensitive information (SSN/TaxID,Passwords ,etc...) ALWAYS needs to be secured, preferably hashed, or at least using very strong encryption.
Security, the more people you give access to the data, the less secure it will become - period. IMHO, it is unconscionable to provide a general list for multiple business to share no mater what the filtering is on that compiled data. Look at the number of data-breaches that are reported daily and we have no idea how many actually happen as business do not appear to routinely disclose such information. And there are criminal organizations that appear to have been using false credentials to appear to be legitimate businesses that have obtained personal information under false pretense. IMHO, it is a better to provide a file with the sub-data to each business as they require it and allow them to build their own records "on the fly."
Although this link relates to Access, the concept of database normalization and structuring will still basically hold true: home > topics > microsoft access / vba > insights > database normalization and table structures
You might also like to review: home > topics > mysql database > insights > mysql basic tutorial
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Burghew |
last post by:
Hi all,
Kindly help me out on this one. I am having a computer shop and we have many
IT related equipments nearly 30 categories which comprises of Servers,
Laptops, PC's, Printers, routers, switches, monitors, Software etc...
Now each of the aboved mentioned category have different attributes such as
Servers may have different configuration...
|
by: lis0122 |
last post by:
I'm creating a mini-CRM system for a couple of our telesales employees.
I have very basic knowledge in Access so bear with me. :) So far I
have three tables...
Contacts (the people to call)
Sales Activity (where call activity is logged)
Topics (product to call for)
I want to be able to continually add contacts to the contact table...
|
by: Petra Chong |
last post by:
Hello all
I am using Python 2.3 and ZODB (without the rest of Zope) with the
following pattern:
* One process which writes stuff to a ZODB instance (call it test.db)
* Another process which reads stuff from the above ZODB instance
test.db
What I find is that when the first process writes, the second doesn't
|
by: Magnus |
last post by:
I'm testing walkthrough saving data to a Database (Multiple Tables).
http://msdn2.microsoft.com/en-us/library/4esb49b4(VS.80).aspx
In the famous Customer/Order example, I'm getting referential integrity
problems "The INSERT statement conflicted with the FOREIGN KEY
constraint..." if the identity/primary key column is "out of sync" with the...
|
by: mca47378 |
last post by:
Hi,
I attached my database on different machine. Everything seems to be okay as of now, but I dont see my database diagrams here, which I had created and saved on the previous machine in this database.
Can anyone please suggest me cuase.
Thank you,
Mithalesh
| | |
by: pratap123 |
last post by:
Hi,
I need to refer multiple different web services at runtime(though one a time) and then invoke the method of this web service based on client choice. Can anyone help me here to create such a web service client in .NET 2.0 ?
Is there any dll or toolkit that can give me capability to refer the web service given its wsdl url and let me invoke...
|
by: RyGa |
last post by:
I know this is a bit off-subject, but not completely..
I am getting fed up opening multiple different browsers to test layout
render for a given page..
I am wondering if there is a utility that can launch an entered url in
different (installed) browsers?
eg. Internet Explorer, Firefix, Opera, Safari
|
by: Jeff |
last post by:
hi
asp.net 2.0
sql server 2005
I have a GridView on my webpage. Sometimes I want to query the bound
datasource in different ways.:
- Get all arroved records
- Get all unapproved records
- Get all records created last week
|
by: =?Utf-8?B?Z2lkZHk=?= |
last post by:
hi,
I posted here earlier with a great reply:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.dotnet.languages.csharp&mid=ed6d7673-0e25-417d-849b-c4b270c76044&sloc=en-us
Something like this works nicely:
List<Personps = new List<Person>();
ps.Add(new Person("Gideon",15));...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
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...
| | |
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...
|
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
