Solved

database er diagram  desgin user credit equal 0 after expiry date

Posted on 2012-12-24
2
497 Views
Last Modified: 2013-01-09
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 :)
0
Comment
Question by:afifosh
2 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 500 total points
ID: 38718077
0
 
LVL 1

Author Comment

by:afifosh
ID: 38718080
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 ..
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question