Home » SQL & PL/SQL » SQL & PL/SQL » Rental Management ERD (Oracle XE)
Rental Management ERD [message #572761] Mon, 17 December 2012 08:31 Go to next message
whmemon
Messages: 25
Registered: July 2011
Location: Pakistan
Junior Member

I want to know how to design the ERD for Rental Management like I want know how to design tables to check every month's rent. Is there any way to store month and year with out day in database ? i will help to compare if rent of particular month is deposited or not ?
Re: Rental Management ERD [message #572764 is a reply to message #572761] Mon, 17 December 2012 08:39 Go to previous messageGo to next message
BlackSwan
Messages: 21940
Registered: January 2009
Senior Member
we don't do homework for you

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

http://en.wikipedia.org/wiki/Third_normal_form
Re: Rental Management ERD [message #572772 is a reply to message #572764] Mon, 17 December 2012 09:30 Go to previous message
whmemon
Messages: 25
Registered: July 2011
Location: Pakistan
Junior Member

Okay
Previous Topic: regexp_replace with clob
Next Topic: sql query to display the repeated column values as null
Goto Forum:
  


Current Time: Thu Apr 17 14:13:41 CDT 2014

Total time taken to generate the page: 0.10522 seconds