Reporting database assignment

When preparing your report for the database assignment, you are asked to include the following items.

1. A description of the database problem tackled.
2. Explain the system and its main functions in the wider context and with the people (actors) with whom it will interact.
3. An ER diagram for the application, showing the various classes identified and their associations. You must use ERD notations.
4. Evidence that you have undertaken normalization and the subsequent relations that you will implement in the software, showing the attributes and keys together with their field type and picture (the type of data text, date, number, etc.).
5. A small sample of the data in the basic relations set up in the database. This could include some real data taken from the excel data.
6. Designs for data input forms properly.
7. Very brief description of how the system is operated and the commands used to undertake each task. (Note: it is assumed that this is done by using interactive commands of the database package, not by any programming.)
8. The total report should be about six pages of carefully laid out text, figures and diagrams, with an absolute maximum of eight sides of text including all examples of printouts or other necessary computer-generated reports. Reports must be permanently bound (for example, well stapled, not secured by paper clips or slipped as loose pages into plastic binders). Each page should be numbered and should have your student number on it. The report must be produced with the aid of a word processor and you are expected to insert relevant diagrams or screen shots into the text. Diagrams should either be prepared using a computer package, or perhaps done by hand and scanned in to the document if you are a talented artist.

Order Customer PKID Ship Mode PK ID E order Date + PK ID customerName shipDate type 0 FK segment_id FK shipMode_id city 0 FK customer_id Segment state FK product_id PK | ID country discount product type postalCode profit SubCategory shopping Cost + PK ID FK subCategory_id productName + PK ID o FK order Priority_id type Order priority o FK category_id PKID + type category PKID 1 Name