sir, i am a fresh B.S in computer science and enggineering,respond at kopra@rediffmail.com RESUME OF MATHEW THOMAS

 NAME: MATHEW THOMAS

 AGE : 22

 SEX : MALE

 ADDRESS : 207/B, JWALAGIRI,AMBALAMUGAL,
COCHIN,KERALA 682302

EDUCATIONAL QUALIFICATIONS

B-TECH IN COMPUTER SCIENCE UCE , THODUPUZHA, 2001 68%
AND ENGINEERING KERALA
(TILL 7TH SEMESTER)

12 TH CRS,AMBALAMUGAL, 1996 68%
KERALA

10TH CRS,AMBALAMUGAL, 1994 76%
KERALA




 EMAIL ADDRESS: mathewtk27@hotmail.com

 LANGUAGES KNOWN: C,C++,JAVA,C#(C-SHARP)

 EXPERIENCE TAKEN : WORKING AS TECHNICAL EXPERT IN SABHEER
BHATTIA'S ARZOO.COM FROM FEB 2001
AS A TECHNICAL EXPERT IN C,C++ & JAVA.

 PLATFORMS WORKED : DOS,WINDOWS,UNIX

 MINI PROJECT : COMPLEATE WEB DESIGN OF THE COLLEGE

 MAIN PROJECT : ABSCENTESE RECORD FOR SIRI
TECHNOLOGIES,BANGLORE

 PACKAGES KNOWN : VB

 DATE OF PASSING: APRIL 2001

ALL THE STATEMENTS ABOVE ARE TRUE TO MY BEST KNOWLEDGE
MATHEW THOMAS

:Sir..

I am in T.E(I.T)

Sir can you give me the project guide..line(mini project..through java)
also give me some suggection..

I am interested in the web ..developing..

web related ...topic...send me..

if possible with code..

BSc Computing
Systems Analysis and Design

Issue Date 04th October 2012

Assignment Date Due:
18th December 2012

Date Returned: 10th January 2013
Weighting: 100%


Assignment Description

CASE

SMITH’s GALLERY OUTDOOR AND LEISURE ORDER PROCESSING SYSTEM

Introduction

Smith’s Gallery of Outdoor and Leisure is a Catalogue mail order company specialising in good quality outdoor and leisure furniture. Fast order processing is essential for mail order firms to compete effectively, and Smith’s Gallery is no exception.

A system is to be set up to manage a computerised mail order system for Smith’s Gallery out of the Company’s existing manual mail order processing system.

After initial consultation with Company employees, the following data items have been identified as essential.

Customer Identification Number, Customer Surname, Customer Name, Customer Address, City, State, Zip, Phone, Credit Card Type, Credit Card Number, Order Identification Number, Order Date, Order Shipment Date, Item Identification Number,
Item Quantity Ordered, Catalogue Identification Number, Catalogue Description, Catalogue Price, and Catalogue Quantity On Hand.

This is the minimum set of data attributes required.

The following business rules have also been established:
• One customer places one or more orders.
• Each order can have one or more items.
• Ordered Items are selected from the Company’s Mail Order Catalogue

Other business rules may need to be defined.










Task

Your task is to design and install a database for the Smith’s Gallery Mail Order Processing System using ORACLE DBMS.

Other business rules may need to be defined.

This will involve the following subtasks:
• Identify the entities required and draw an ERD using Select Yourdon or another appropriate tool.
• Identify some of the systems development methods which are available for this software development project.
• Produce a DFD 0 and DFD 1 (following SSADM terminologies) for the organisation using a software drawing tool.
• Identify and justify any additional data fields.
• Identify and justify any additional business rules.
• Use normalisation to design the database.
• Ensure that you have the minimum number of tables for controlled redundancy.
• Indicate the primary and foreign keys for each table.
• Write a script to create the tables, including appropriate constraints and optimisation.
• Write a script to insert meaningful test data into the relevant tables.

Deliverables
Task 1 Written report to include:
• An introduction and assumptions, including new business rules.

• Identify some of the systems development methods which are available for this software development project. Recommend, with justifications, the method you would select for the Smith’s Gallery.


Task 2. DFD 0 and DFD 1 (following SSADM terminologies) using a software drawing tool.

Task 3. The Entity Relationship Diagram (ERD).

Task 4. Normalisation (1NF, 2NF, 3NF)

Task 5. A hard and working soft copy of the working script used to create the tables.

Task 6. A hard and working soft copy of the working script used to insert test data.