Show Bid Request small database project Bid Request Id: 12810 Bookmark in my 'To Do' list Posted by: mohamed1421 (9 ratings) (Software buyer rating 9.33) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Excellent Approved on: Apr 6, 2002 1:11:18 PM EDT Bidding Closes: Apr 8, 2002 1:28:05 PM EDT Viewed (by coders): 347 times Deadline: 4/14/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Database, Graphics / Art / Music, Java Enter chat room for this bid request (0 active users at Sep 8, 2003 8:01:27 PM EDT) Description: I am looking for a database system for a video store I have created the tables below and I will provide some sql queries later and also open for suggestions from ur part to Develop query/search system. , I need it to be in JDBC, the interface should be graphical should have user inputed search, u can call the table below from any where u want Acess for example CUSTOMER -------- |- driver's_license_# (primary key) |- first_name |- middle_initial |- last_name |- gender |- date_of_birth |- st_address |- appartment |- city |- state |- ZIP |- home_phone_# |- work_phone_# |- cell_phone_# ACCOUNT ------- |- account_id (primary key) |- issuing_date |- balance TITLE ----- |- title_id (primary key) |- name |- rating |- year |- type (ex. movie, music, game) |- subtype (ex. country, western, action, adventure, thriller, rock, pop ... etc) |- media_type/platform (ex. DVD, CD, PS2, XBOX ... etc) |- #_of_discs |- total_quantity (including both in-stock and rented) RENTAL ------ |- rental_id (primary key) |- from |- to STUDIO ------ |- studio_id (primary key) |- name |- location |- year_established |- owners (this can be just a string list of owners; i.e. no constraints at all) COPY (this is a weak entity) ---- |- copy_id (primary key) ARTIST ------ |- artist_name (primary key) |- gender |- date_of_birth STORE ----- |- store_id (primary key) |- st_address |- city |- state |- ZIP |- year_established |- owner ORDER (here we'll assume that each order contains only one title, no matter what the quantity is) ----- |- order_id (primary key) |- from_studio |- title_ordered |- unit_price |- quantity_ordered |- status |- shipping_date |- order_price DEPARTMENT ---------- |- department_id (primary key) |- name EMPLOYEE -------- |- SSN (primary key) |- first_name |- middle_initial |- last_name |- gender |- st_address |- appartment |- city |- state |- ZIP |- home_phone_# |- cell_phone_# |- date_of_birth |- wage_type |- wage_amount Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Platform: jdbc Must be 100% finished and received by buyer on: Apr 14, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! kurtn (33 ratings) in Norcross, Georgia United States Bid id: 142,015   $80 (USD) Apr 6, 2002 3:00:07 PM EDT  9.51 (Excellent)     Hi! I am interested in working on this project for you. I have over 7 years of industry experience programming in Java and C++. I have also earned the Sun Certified Java Programmer and Oracle Certified Enterprise Java Developer certifications. I am also very experienced in using JDBC and in creating Java GUI Applications/Applets, having worked on projects similar to yours.