•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 456,432 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,604 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 2612 | Replies: 19
 |
•
•
Join Date: May 2007
Posts: 7
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
@ ithelp can u explain how wrote M:n between customers and loan
only 1 customer wud take 1 or many loan at a time
many customer wont take 1 loan at a time.
only 1 customer wud take 1 or many loan at a time
many customer wont take 1 loan at a time.
•
•
Join Date: May 2007
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
18th may is friday
•
•
Join Date: May 2007
Posts: 9
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
yes it is due on friday
i'll send the relationship diagram can u plz let me know wether the relationship is correct or not
i'll send the relationship diagram can u plz let me know wether the relationship is correct or not
•
•
Join Date: May 2007
Location: Warrington, England
Posts: 31
Reputation:
Rep Power: 2
Solved Threads: 2
Light Poster
Re: assignment help Hey,
I've Attached The Relationship Diagram.
It Might Not Mean Very Much Without The Table Contents To Flesh It Out. But I'll Get To That Soon.
How Much Detail Do You Want To Go Into With The SQL. I'm Writing Stored Procedures & Functions To :
Manage Staff (Add, Change, Remove)
Manage Customers (Add Change, Remove)
Manage Items (As Above)
Manage Loan Transactions...etc
Hope This Helps.
I've Attached The Relationship Diagram.
It Might Not Mean Very Much Without The Table Contents To Flesh It Out. But I'll Get To That Soon.
How Much Detail Do You Want To Go Into With The SQL. I'm Writing Stored Procedures & Functions To :
Manage Staff (Add, Change, Remove)
Manage Customers (Add Change, Remove)
Manage Items (As Above)
Manage Loan Transactions...etc
Hope This Helps.
•
•
Join Date: May 2007
Posts: 9
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
hi Rob ,,
how r u. thanks for ER diagram. Rob i'm sending u the tables this is according to my knowledge u tell me wats wrong with this waiting for ur reply
table 1 table 5
books: Condition_codes:
Book_id Condition_code
Book_title Condition_description
Book_pg_no
Category_name table 6
Rental_dialy_rate Categories:
Condition_code Categoy_name
Category_description
table 2 Daily_overdue_rate
Video:
Video_id table 7
Video_title Rental_status_code:
Video_length Rental_status_code
Video_description Rental_status_description
category_name
Rental_daili_rate table 8
Format_Types:
table 3 Format_type_code
Customer: Format _type_description
Customer_id
Customer_first_name table 9
Customer_last_name Staff_members:
Customer_birth_date Staff_name
Customer_phn Pay_rate_id
Condition_code
table4 table 10
Customer_rentals: Salary:
Staff_name Pay_rate_id
Item_rental_id Date_work
Customer_id Start_time
Format_type_code End_time
Rental_status_code
Rental_date_out
Rental_date_returned table 11
Rental_amount_due Video_stores:
Store_id Store_id
Store_name
Store_address
Store_phn
how r u. thanks for ER diagram. Rob i'm sending u the tables this is according to my knowledge u tell me wats wrong with this waiting for ur reply
table 1 table 5
books: Condition_codes:
Book_id Condition_code
Book_title Condition_description
Book_pg_no
Category_name table 6
Rental_dialy_rate Categories:
Condition_code Categoy_name
Category_description
table 2 Daily_overdue_rate
Video:
Video_id table 7
Video_title Rental_status_code:
Video_length Rental_status_code
Video_description Rental_status_description
category_name
Rental_daili_rate table 8
Format_Types:
table 3 Format_type_code
Customer: Format _type_description
Customer_id
Customer_first_name table 9
Customer_last_name Staff_members:
Customer_birth_date Staff_name
Customer_phn Pay_rate_id
Condition_code
table4 table 10
Customer_rentals: Salary:
Staff_name Pay_rate_id
Item_rental_id Date_work
Customer_id Start_time
Format_type_code End_time
Rental_status_code
Rental_date_out
Rental_date_returned table 11
Rental_amount_due Video_stores:
Store_id Store_id
Store_name
Store_address
Store_phn
•
•
Join Date: May 2007
Posts: 9
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
i'm resending the table
•
•
Join Date: May 2007
Location: Warrington, England
Posts: 31
Reputation:
Rep Power: 2
Solved Threads: 2
Light Poster
Hey,
I've Attached The Reply.
What About The SQL ? Have You Got SQL Server Or Some Other RDMS To Play With ?
I've Attached The Reply.
What About The SQL ? Have You Got SQL Server Or Some Other RDMS To Play With ?
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Java Assignment Help Needed!!!!!!!!!! (Java)
- Help needed with VB Assignment (Visual Basic 4 / 5 / 6)
- Many Errors while doing this assignment (C)
- I need help on my 'address book' assignment! (C++)
Other Threads in the Database Design Forum
- Previous Thread: Database basic help!
- Next Thread: Database Design for storing versions
