Small Database Project for a small business

Hello, I am a web designer in the process of setting up an online business for one of my clients, I require a small database system for this website - all I need is for you to do the database project, I am taking care of the actual website and my partner is dealing with the integration of the database. You DO NOT have to do any work on the website. I will relay the work you have done onto my partner designer who will deal with it from there. ***It is very small, and anybody with database experience will find it a breeze (hopefully!).*** Due to the nature of the clients business, I am under strict instructions not to reveal too much about this business, and therefore I am going to give as much details as I can before allowing the coder to work on the project - they will then be shown the full scenario of the business. **What I Require for this project: ** - A Data Model to be produced for the given scenario. - A Logical Schema (incl. Integrity constraints for the DB using SQL -- Tables, Identifiers, Foreign keys and Integrity Constraints) - Sample Queries. I will have 4 or 5 queries which will need to run and pull data from the tables. The tables will need to be populated with sample data of about 10 rows (per table), just for testing purposes. A requirement of this project is that I will be able to come back to you once I have passed information onto my partner, to change certain aspects of your work. This will only be minor changes, hopefully! **NOTE:** Bonuses will be paid once the project has been completed and I am satisfied with the results. This is additional to the bid accepted for the work. **EDIT:** **SQL Server 2000** is preferred. There will be about 7 to 9 tables in this database. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Microsoft Windows XP Microsoft SQL Server 2000 or above.