Srs Project
DBIS Project Report
Online Shopping
By Dilys Thomas (98005003) Anureet Saxena (98005006) Pradeep Kumar.R. (98005031)
Guided by Professor S. Sudarshan
Department of Computer Science and Engineering Indian Institute of Technology Mumbai November 25, 2000
a
Contents
1 Introduction
1.1 1.2 1.3 1.4 Overall Description . . . . . . . . . . . . De nitions . . . . . . . . . . . . . . . . . References . . . . . . . . . . . . . . . . . Overview of Developer 's Responsibilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1
1 1 1 2
2 General Description
2.1 2.2 2.3 2.4
Product Perspective . . . . Product Functions Overview User Characteristics . . . . General Constraints . . . . .
3
3 3 4 4
3 Information Description
3.1 Entities and Relationships . . . . . . 3.1.1 Entities . . . . . . . . . . . . 3.1.2 Relationships . . . . . . . . . 3.2 Data Dictionary . . . . . . . . . . . . 3.2.1 Entity item . . . . . . . . . . 3.2.2 Entity supplier . . . . . . . . 3.2.3 Relationshipsupplier-items . . 3.2.4 Entity orders to be placed . . 3.2.5 Entity item authority . . . . . 3.2.6 Relationship manufactured by 3.2.7 Entity priv users . . . . . . .
Online Shopping
By Dilys Thomas (98005003) Anureet Saxena (98005006) Pradeep Kumar.R. (98005031)
Guided by Professor S. Sudarshan
Department of Computer Science and Engineering Indian Institute of Technology Mumbai November 25, 2000
a
Contents
1 Introduction
1.1 1.2 1.3 1.4 Overall Description . . . . . . . . . . . . De nitions . . . . . . . . . . . . . . . . . References . . . . . . . . . . . . . . . . . Overview of Developer 's Responsibilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1
1 1 1 2
2 General Description
2.1 2.2 2.3 2.4
Product Perspective . . . . Product Functions Overview User Characteristics . . . . General Constraints . . . . .
3
3 3 4 4
3 Information Description
3.1 Entities and Relationships . . . . . . 3.1.1 Entities . . . . . . . . . . . . 3.1.2 Relationships . . . . . . . . . 3.2 Data Dictionary . . . . . . . . . . . . 3.2.1 Entity item . . . . . . . . . . 3.2.2 Entity supplier . . . . . . . . 3.2.3 Relationshipsupplier-items . . 3.2.4 Entity orders to be placed . . 3.2.5 Entity item authority . . . . . 3.2.6 Relationship manufactured by 3.2.7 Entity priv users . . . . . . .
References: Abraham Silberschatz, Henry F. Korth and S. Sudarshan. Database System Concepts. McGrawHill, 1996 1 1.4 Overview of Developer 's Responsibilities 2.4 General Constraints This project is to be completed, including coding, testing and loading of the database, by Nov 15, 2000