Browse our collection of papers in
System Analysis and Design

C/C/10. DBMS Schema for 'A Penny to a Pound' shop

WORDS:
1200
DATE:
2005
PRICE:
19.99 GBP

The DBMS schema has been created for a 'A Penny to a Pound' shop to hold the personal information of a loyalty card member, the customers' details, their transactions and the product in the transaction. Each table in the schema include field names, data types, lengths, formats, validation rules, data range and dummy data.

 

KEYWORDS: dbms, schema, penny, pound, shop,