database design (1 Viewer)

Anafer

New member
Local time
Today, 10:38
Joined
Feb 23, 2021
Messages
3
Hi, I was planning to design a database (relational model). Someone with good experience in this matter suggested to me that before choosing a database system I would have to consider the sizing of the database and other factors. I have no idea about those factors¡¡ I have been reading quite a lot and I bumped into a lot of information of database(relational model) however I cannot find information on previous stages of database design to be considered before choosing a database system.
My other concern is:

How can I measure the sizing of the database?
I would appreciate some guidance

Regards
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 05:38
Joined
Apr 27, 2015
Messages
3,254
Very BROAD question Anafer. Can you give some specifics regarding what the DB would be used for? How many users? Equipment available (PC Lan, Citrix server, SQL Server, Sharepoint, etc)

Without some of this answers upfront, this could take a LONG time to answer

Edit: Welcome to AWF, BTW!
 

Anafer

New member
Local time
Today, 10:38
Joined
Feb 23, 2021
Messages
3
Hi, thanks for your prompt reply.

it is a small business. The database will run on local server apache with three small departments (no more than 10 people). We will create a website with PHP to display the information

It a small project.
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 05:38
Joined
Apr 27, 2015
Messages
3,254
Thanks for the info. It appears that a split Access DB (assuming the PC's have it installed) is more than capable to handle the task. Displaying the info to a Web Application is something I know very little about. But don't you worry, the Calvary is not far behind me...I'm more or less a scout!
 

Anafer

New member
Local time
Today, 10:38
Joined
Feb 23, 2021
Messages
3
Thanks again¡
Giving you a bit more details (PHPMyAdmin) + Mysql + php+ HTML
 

jdraw

Super Moderator
Staff member
Local time
Today, 05:38
Joined
Jan 23, 2006
Messages
13,541
If you are going to or are using MySQL, then where/why would Access fit?
Seems you have identified a common approach ((PHPMyAdmin) + Mysql + php+ HTML).
Perhaps there's more to your question and intent. Lots of info on youtube and net.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 10:38
Joined
Sep 12, 2006
Messages
14,220
Access is great for databases, but doesn't interface with websites.
Access databases can handle data sizes up to 2Gb, which is generally around a million or more records of data, give or take. Sufficeint for most SME's.
 

Users who are viewing this thread

Top Bottom