E-commerce-Design

a database semester project #More Description

1. Introduction to the working of the system
2. Problems in the existing system (optional)
3. ERD of the system
4. Relational Schema evaluated using Normalization
5. Description of the relations in the following format: Table Name: Student Attribute Data Type Size Constraints RegNo Varchar2 10 Primary Key SName Varchar2 15 Not Null Program Varchar2 3 Can be ‘BS’, ‘BBA’, or ‘BA’ NIC Varchar2 15 Unique
6. CREATE TABLE statements against all the relations of your system.
7. Batchman Diagram showing the association among different relations of the relational schema.
8. Select statement for at least five common reports to be generated by the system