assignment help

[mandy2612]

hi i'm an absolute fresher in DBMS and our teacher gave us an assignment in this there are two questions,
we have to draw the UML diagram,
find the association,
ER diagram,and then to write SQL queries
the problem is that i'm little bit confused about the attributes i think this is the first step so can u help me in making the UML diagram
as soon as possible
i have attached my views
thanks

[ithelp]

Storeloan has 1:n relation with Video Iid
Storeloan has 1:n relation with Books via Iid
Storeloan has m:n relationship with Customers
By the way no one will do you assignment unless if you put some effort on it.

[mandy2612]

yes i knw that no one will do my assignment thats why i just asked for checking that attributes and nothing else so that i can make the UML diagram understood

[patrick18]

au

[mandy2612]

hi
yes i'm,,
and wat about u

[patrick18]

yes same

[mandy2612]

so
wat course r u doing and where.
wats ur name ,, and whr r u from basically

[patrick18]

dmdd wat bout u

[patrick18]

is this assign for u due on friday

[mandy2612]

sr wat is dmdd
and my assignment is due on 18th may

[patrick18]

@ 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.

[patrick18]

18th may is friday

[mandy2612]

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

[patrick18]

ok

[SkinHead]

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.

[mandy2612]

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

[mandy2612]

i'm resending the table

[SkinHead]

Hey,

I've Attached The Reply.

What About The SQL ? Have You Got SQL Server Or Some Other RDMS To Play With ?

[mandy2612]

sry but i dont knw how to send private msges on daniweb can u tell me plz

[SkinHead]

I've Attached The SQL & Explanation For Both Queries

I Hope This Helps.

Rob