small database project
$30-80 USD
Dibayar semasa penghantaran
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
ID Projek: #2845341