mySQL Database Creation/Modification/Normalization
€250-750 EUR
Оплачується при отриманні
Description: This is what we need exactly. More Details in PDF.
Our future Dashboard will have a REGISTER page. Dashboard is under construction by your fellow Freelancer and you will cooperate with her.
1. When user registers on our site, with completed registration, user must enter the Device ID (IMEI, in database that is the field ‘deviceIMEI’). That will fill the table userAccount and userIMEIs. After that, in Dashboard itself, user will have a button to add new device (IMEI) to his account.
2. So, let’s say, in future, for each region we will have a new database named (in example) “DeviceData_EUROPE” and every user that open account from Europe(based on IP address) will get his own table for the future data storage. We don’t care if someone uses VPN, it is not very important.
3. The userAccount table example is here with this pdf, here you can see the fields. Like the whole Database, download it.
Now, Most important:
1. There should be some references to databases (we need pointers). We have a table for users, named userAccount, there is stored userAccountID. This userAccountID is key for future data representing. Because Dashboard should always represent only devices that are registered to users.
2. We have table userIMEIs where one user is connected to one or multiple devices.
3. Now, the tables for data: dataCounters, dataTemperature, dataLocation, dataParameters1, dataParameters2.
4. When someone wants to look at some device on the dashboard, dashboard will give the data from counters for all devices that are registered to user for last 7 days (by Default). After that, user can select the only one device and date to see just the data for that particular device (devices are filtered by IMEI) for selected date.
ID Проекту: #20152693
Про проект
36 фрілансерів(-и) готові виконати цю роботу у середньому за €546
Hello, I have read through the details of your job. I have seen the SQL file as well as the PDF you have given. The description which you have given in the project (same as in the PDF) has some questions, which I woul Більше
Hi, ready to build the mySQL database you need. I have reviewed your PDF file and read your requirement details and understand that. I can done work and deliver you files in 4 days.
Oh, Dear,sir. Thanks for sharing your project with me. I hope you feeling always good. Senior developer is here. I can sure you will feel satisfy if you hire me. I have good skills and experience of 10 year develop Більше
Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a Більше
Hello. How are you today? I've read your job post carefully. This job really attracts me and also your required skills are completely matched with my major skills. I have good knowledge and rich experience with it. I b Більше
I have many experiences in mysql, php. I can show you my projects via chatting. I can complete your project successfully. Thanks.
Hi, How are you? Hope you are going well! I checked your project carefully, so that i feel very confident in your project because I am talented web,python,mobile app developer with 6 years experiences. If you give me Більше
Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (th Більше
Thank you for reviewing my qualifications. I am a high-level programmer and who prefers to work alone. I do not outsource any projects in order to maintain quality control. I provide free project support from beginning Більше