build a small MS Server with some queries before 23:30 CET
€250-750 EUR
Betalades vid leverans
Business Requirements:
1. Only the bicycle (fiets) have inshurence.
2. Bicycle (fiets)are able to swap if there is a spare, not recerverd bike
3. Email must be unique
4. The staff worsk in multiple jobroles.
5. Accessories alike hemlets ectr. Are avible to rent only if the customer rents a bicycle (see
fiets table)
6. The sex off the customer needs to be; ‘M’ (male) or ‘F’ (Female)
7. The final rentdate from rent (bikes and/or accessories) needs to be a on a later date then the
rent startdate
8. The damage paydate must be later the damage startdate
9. Seven relevant constraints (based on stored procedures )
9.1. insert rules:
- email must be unique,
- rent date must be on or after the current date
9.2. Update constrains:
- cannot make a booking if email is NULL
- cannot change ID
- returns a error if the ID does not exist
9.3. Delete Rules:
- only able to delete one record at a time
- maintain a log when a account is created, updated, deleted for datamining.
10. Sort all bicycles on type [electric, m/f)
11. Create views via userinput the following results for one month, per quarter, or for one
year:
- a damagereport for the bicycles only (becaue the accessore are NOT insured.)
- all the rents are based on a selected klant_ID.
- all customers who have rended a bicycle
- all the damaged bicycle within the selected period.
- all customers who have rented a bicycle within a timeframe listed above.
- the revenue for a selected month, quartal, or year.
- the most rented bicycle
- the lease with the highest turnover.
- the loss per year
- bike with the most damage
- customers with unpaid bills
12. Show a distinct view of bicycles and accessories based on a specific (rent_ID) )
verhuur_ID
13. Build in Acces the following:
Build a rapport in Access:
A. Overview from the rented bicycles
B. List with not rented bycicles nog niet verhuurd zijn in 2015
C. convert every month ieder from the year 2010 untill 2016
D. Overview from the top 10 polular bicycle
Projekt-id: #12885009
About the project
23 frilansare har lagt bud på i genomsnitt €551 för det här jobbet
i am a lead .Net software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
Hi, I am a professional Database expert with over 3 years of experience. I have read your request and interested to work for you as I am expert of SQL, Database implementation etc and can do this task for you within 10 Mer
I have 10 years experience Kindly send me details , the PDF not clear Do you need to create database or you have one and need query Best Regards, Hassan
hello,how are you.i read your bid carefully. i am java/javafx expert and have full experience for 12 years. java/javafx is my top skill and passision. i can provide most quality and high speed. if you want to succe Mer
Hello I have read what you exactly need. However, I would like to ask you a few questions. I do work in a smart way and do not rest until I get the job done. Please feel free to contact me anytime so we can have a deta Mer
Hi, I am a SQL developer with over 8 years of experience. I can complete this for you in time. I can complete this for you in time.
A logical, analytical thinker with excellent managerial skills possesses 2.5+ experience as a Database Developer and DBA Administrator. Extensive experience in writing stored procedures, functions and views. Extensiv Mer
If awarded to do this project, I will get in touch and make clarifications where need. With this done, I can deliver earlier than the time specified.
Hi I'm a junior SQL server developer and also a student in the fourth year in computer science I ready to do this project, but I'm under qualified for this task if you need less experience, I'm here thanks for your Mer
