<div>
i don't want a program to design .. i want someone can help me or give idea how to design the ER diagram of my request...<br />
<br />
i can do this using phpmyadmin or using mssql for design ..
</div>


i don't want a program to design .. i want someone can help me or give idea how to design the ER diagram of my request...

i can do this using phpmyadmin or using mssql for design ..

<div>
<div class="content wysiwyg-content">
i have a table user contain member details &nbsp;and each member have a credit <br />
this credit &nbsp;has a expiration date can anyone help me or give me an idea how i can implement the ER diagram <br />
<br />
the credit maybe will be for two or three month &nbsp;and some user don't have expiration date for him credits <br />
<br />
if any exerts can help me on desgin or ..<br />
<br />
create table usres <br />
field : userid p.k , username , password <br />
<br />
create table usercredits<br />
field creditid , userid , fromdate , todate , creditnumber,status<br />
<br />
where todate is expirydate.. <br />
fromdate todate maybe it will be for one month or ...<br />
<br />
i can run a trigger on the table usercredit to check if getdate &gt;&nbsp;todate status is expired <br />
than he can user the available credits.<br />
<br />
hope anyone can help me in implementation :)
</div>
</div>


i have a table user contain member details  and each member have a credit 
this credit  has a expiration date can anyone help me or give me an idea how i can implement the ER diagram 

the credit maybe will be for two or three month  and some user don't have expiration date for him credits 

if any exerts can help me on desgin or ..

create table usres 
field : userid p.k , username , password 

create table usercredits
field creditid , userid , fromdate , todate , creditnumber,status

where todate is expirydate.. 
fromdate todate maybe it will be for one month or ...

i can run a trigger on the table usercredit to check if getdate > todate status is expired 
than he can user the available credits.

hope anyone can help me in implementation :)

database er diagram  desgin user credit equal 0 after expiry date

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.