Am creating an Online house rent system that will enable tenants to pay house rent online,check statements,a caretaker to write reports,landlord to write statements,add new tenants. I welcome all your ideas on how to go about it.The database requires either Ms-Excel or Mysql.
Sydique 0 Newbie Poster
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Start by writing down what you need. If you have that then it's easier to plan all the separate parts.
diafol
Don't use MSExcel if you can help it. You can output and input to MySQL by a number of methods (e.g. csv).
As pritaeas says, write down your needs.
I find it useful to draw diagrams (e.g. data inputs and interactions, 'entities', views and outputs)
Once you have a good idea of all the data you need to store and serve, then you can build your relational DB schema.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.