Designing a database for c# program and UI

Question

Hello Guys I'm very happy to signed up in this forum I want to make a c# WFA program and just do CRUD with entity framework orm just need some help about design database and relation between tables and a bit UI First I want to register a user with this Fields [Code(pk) - FirstName-LastName-PhoneNumber-Date-Description] i need this information about my user in one form another form is related to that user with these fields (Age-Height-Weight-BMI-Gender) another form is about that user history of paying for example user come to my store and pay 15 $ i want to save the date of that and the price .... what should i do ? make 3 tables or ... ? Regards

Bidyasagar Mishra · Answer

Hi Armin, U need to create two table, one is user table and another is payment table . In the first page insert the record , in the second page update the user record Table script: User Table: CREATE TABLE [dbo].[UserTable]( [code] [ int ] IDENTITY(1,1) NOT NULL , [FirstName] [nvarchar](50) NULL , [LastName] [nvarchar](50) NULL , [PhoneNumber] [nvarchar](12) NULL , [Age] [ int ] NULL , [Height] [ numeric ](3, 2) NULL , [Weight] [ numeric ](5, 2) NULL , [BMI] [nvarchar](50) NULL , [Gender] [ bit ] NULL , [Description] [nvarchar]( max ) NULL , [ Date ] [ date ] NULL , CONSTRAINT [PK_UserTable] PRIMARY KEY CLUSTERED ( [code] ASC ) WITH (PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [ PRIMARY ] ) ON [ PRIMARY ] TEXTIMAGE_ON [ PRIMARY ] Payment table: CREATE TABLE [dbo].[PaymentTable]( [Id] [ int ] IDENTITY(1,1) NOT NULL , [UserId] [ int ] NULL , [payment] [ numeric ](18, 3) NULL , [ date ] [ date ] NULL , CONSTRAINT [PK_PaymentTable] PRIMARY KEY CLUSTERED ( [Id] ASC ) WITH (PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [ PRIMARY ] ) ON [ PRIMARY ] GO

Designing a database for c# program and UI

Answers (1)