Database Design and Development
- or -
Post a project like this- Posted:
- Proposals: 5
- Remote
- #1463612
- Awarded
Description
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: I already have a structure \ database map in mind, but I think there may be a more skilled database designer out there that could come up with what I need.
The table types \ entities that I am looking for are as below and would like a table history where applicable too so that I can audit and track changes.
As well as the tables \ Entities I am also looking for the necessary sprocs to insert update and do soft deletes
Account Type
This will determine if the user is a customer or a supplier
user
This will hold User Name, Password, address and contact information
Password MUST be encrypted in and by the database
UserLocation
this should hold 4 fields with names and types
UserId Int
Lattiture Float
Longitude Float
GeoLocation Geography
AnimalType
Although primarily site will be for dogs there is a chance that I may in the future need to scale this out
Animal Size
size of animal - small, med...
Animal Details
Animal Name
Age
Microchiped
Microchip Number
Steralised \ Neutured
Flea, Worming, Kenel Cough and Injections all up to date
Has medical needs
Special Intstructions
Medical Needs
relationship between Animal Details Table to show medical issue \ illness disease and treatments needed
Illnesses and Diseaesed
list of known illnesses \ diseases - I can provide data to populate the table if needed
Animal Behaviours
I have a list of behaviours that I want use to confirm they are ok with as a supplier and as customer how their dog \ animal behaves.
Animal Routine
Number of Meals
Times of meals
sleeping location
Number of walks in the day
Times of Walks
lead walks only
Duration of the day animal can be left alone in the home
Special Intstructions
Vet Information
Name, Address, contact info...
Bookings
UserId - Customer
userId - Supplier
Booking Start Date
Booking End Date
Payment Method
Payment Reference
Refunded
Refund Reference
Specific technologies required: MSSQL Server - 2012 or above
Extra notes: When quoting for the work please tell me
* How long you expect this to take,
* What SQL Server Version you will be using so that I can setup the necessary environment
* What other projects you have conducted in the past similar to this
* How you plan on encrypting the password field to take in a string from the website
I have other database work that I will need completing soon too so repeat work may be an option for the assigned developer if any good.
Anyone wanting to contact me please do not track me down to my work place via Linked In will be reported to PPH as this is completely unprofessional on your part and this will not be tolerated.
This is a fixed price job as detailed, any bidder wanting to change the pricing structure and charge hourly after the job is awarded will be removed and the job immediately. Further to this note any 'placeholder bids' will automatically be rejected.
When quoting please provide an accurate quote for the job.
Simon P.
100% (7)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hey Simon,
Thanks for detail! I have some queries!
Please open PMB for a brief discussion over the project.
Thanks & Regards,
SeanSimon P.16 Feb 2017what is your skype id
Sean S.16 Feb 2017Thank you Simon.
Please note as per PpH norms we cant share any contact details.l guess that's not the case with you as buyer.
If you can do the needful,that would be appreciated.
Warm regards.
Sean -
You've posted this job before. Can I ask why it's come back on - before I decide whether it's worth bidding on!
Simon P.16 Feb 2017Its come back on because the winning bidder for the job decided they wanted to change payment from an agreed fixed fee to £40 an hour because I wouldnt take him on as a business partner.
-
Send me invitation
Simon P.16 Feb 2017You missed out the word please, and youre more than welcome to bid for the work. However given your lack of manners I wouldn't hold your breath that you would be considered