May 25, 2006 at 7:13 pm
Its my first experience .I have done some work but I want that some one check my work .Is it correct or not ? OR its relations and its primary keys are correct .please help me about
We make a Point of sale system for mobiles. it’s a online application that’s keep all records in database.
1. Sales
2. SalesReturn
3. SalesLineItem
4. Commission
5. Store
These tables attributes are as:
Sales: (saleId, mobileNo, customerName, amount, storied, saleBalance,
SaleDate, itemCode, unitPrice, croId, commissionCode, returnId)
Sales Return: (returnId, customerNo, dealerCode, paymentMade,
InvoiceNo, invoiceDate, SIRNO, SIRDate)
Store: (storeId, storeAddress, storeName)
SalesLineItem: (itemCode, quantity)
Commission: (commissionCode, description, newSaleRegularCommission,
NewSalePrepaidCommission, rechargeCommission, hardwareCommission, witholdingTax, firstSaleWithoutCommission)
Sales table is the main table its primary key is the saleId
SalesReturn: table have returnId as a primary key and return Id represent as a foreign key in the sales table .
Store: table primary key is the StoreId and storeId represent as a forigen key in the Sales table.
SalesLineItem: item Code is the primary key and this represent as a forigen key in the sale table.
Commission: In Commission table commissionCode is a primary key and commissionCode represent key as a sale table.
May 26, 2006 at 3:23 am
just a thought
customers are an entity
Sales: (saleId,, customerID, amount, storied, saleBalance,
Customer: (customerID,mobileNo,CustomerName)
MVDBA
May 26, 2006 at 3:26 am
SalesLineItem: (itemCode, quantity)
where is the reference to saleID
perhaps
SalesLineItem: (ID(PK),saleid(FK),itemCode(FK), quantity,)
MVDBA
May 29, 2006 at 3:32 am
In Customer Table We add all the customer related information.Such as
Customer: (customerNo,mobileNo,customerName,userName,telephoneNo,
officeAddress,residenceAddress,residenceAddress,customerNIC,customerNTN,
PassportNo,previousMobileNo)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply