Security Shop Data Model and Description

3.0 Data Model and Description
3.1 Data objects
      3.2 Relationships
3.3 Complete data model
 

1.0

2.0

3.0

4.0

5.0

6.0

7.0

Introduction

Usage scenario

Data Model and Description

Functional Model and Description

Behavioral Model and Description

Restrictions, Limitations, and Constraints

Validation Criteria

Surveillance / Security Camera Installation and Maintenance Shop Requirements

Security Camera Installation

3.0 Data Model and Description
Data Model represents the software functional description. The Object diagram describes about the classes, their attributes and the relationships among them.

3.1 Data objects

1. CUSTOMER_INFO
This table stores the basic information of the Customer to extract the information regarding the order details, payment details and general Information.

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Customer_Id

Number

8

N

Primary Key

2

Login_Id

Number

8

N

Foreign Key on Login_Id from Login.

4

First_Name

Varchar2

10

N

 

5

Last_Name

Varchar2

10

N

 

6

Addressline1

Varchar2

15

N

 

7

Addressline2

Varchar2

15

N

 

8

City_Id

Number

5

N

Foreign Key on City_Id from CITY_MASTER

9

State_Id

Number

5

N

Foreign Key on State_Id from STATE_MASTER

10

Zipcode

Number

6

N

Foreign Key on Zipcode from LOC_MASTER

11

Day_Phone

Number

10

N

 

12

Mobile_No

Number

10

N

 

13

Email

Varchar2

20

N

 

15

Exist

Boolean

 

N

Check Constraint (‘0’, ‘1’)

 

2.  ORDER

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Order_Id

Number

8

N

Primary Key

2

Customer_Id

Number

8

N

Foreign Key on Customer_Id from CUSTOMER_INFO.

3

Price_Id

Number

8

N

Foreign Key on Price_Id from SHIPPING_PRICE

4

Price

Number

5

N

 

5

As_On_Date

Date

 

N

 

6

Exist

Boolean

 

N

Check Constraint (‘0’, ‘1’)

 

3. Return

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Order_Id

Number

8

N

Primary Key

2

Customer_Id

Number

8

N

Foreign Key on Customer_Id from CUSTOMER_INFO.

3

Price_Id

Number

8

N

Foreign Key on Price_Id from SHIPPING_PRICE

4

returnId

Number

5

N

 

5

As_On_Date

Date

 

N

 

6

Exist

Boolean

 

N

Check Constraint (‘0’, ‘1’)

 

 

 4. SHIP_TO

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Customer Id

Number

8

N

Foreign Key on Customer_info from VEHICLE_INFO.

2

Customer Name

Varchar2

10

N

 

3

Addressline1

Varchar2

15

N

 

4

Addressline2

Varchar2

15

N

 

5

City_Id

Number

5

N

Foreign Key on City_Id from

6

State_Id

Number

5

N

Foreign Key on State_Id from

7

Zipcode

Number

6

N

Foreign Key on Zipcode from

8

Day_Phone

Number

10

N

 

 

5. SHIP_FROM

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Company Name

Varchar2

10

N

 

2

Addressline1

Varchar2

15

N

 

3

Addressline2

Varchar2

15

N

 

4

City_Id

Number

5

N

Foreign Key on City_Id from

5

State_Id

Number

5

N

Foreign Key on State_Id from

6

Zipcode

Number

6

N

Foreign Key on Zipcode from

7

Day_Phone

Number

10

N

 

 

6. Login

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Login_Id

Number

8

N

Primary Key

2

Password

Varchar2

15

N

 

3

User_Type

Varchar2

15

N

 

4

Exist

Boolean

 

N

Check Constraint (‘0’, ‘1’)

 

7. Camera Type

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Camera TypeId

Number

8

N

Primary Key

2

Camera Name

Varchar2

15

N

 

3

Camera Description

Varchar2

max

N

 

4

IR_LED

Number

8

N

 

5

IR_LED working Distance

Number

8

N

 

6

Water Resistance

Varchar2

2

N

 

7

Lens

Varchar2

4

N

 

8

Voltage

Number

8

N

 

9

Dimension

Varchar2

10

N

 

10

Weight

Number

8

N

 

 

8. DVR Type

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

DVR Type ID

Number

8

N

Primary Key

2

DVR Type Name

Varchar2

15

N

 

3

DVR Type Description

Varchar2

max

N

 

4

Compression Format

Varchar2

8

N

 

5

Resolution

Number

8

N

 

6

Playback Resolution

Varchar2

2

N

 

7

Real Time Recording Support

Varchar2

4

N

 

8

USB Port

Number

8

N

 

9

Weight

Number

8

N

 

10

Exist

Boolean

8

N

Check Constraint (‘0’, ‘1’)

 

9. Security Cameras and DVR Accessories

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Accessories ID

Number

8

N

Primary Key

2

Accessories Name

Varchar2

10

N

 

3

Accessories Description

Varchar2

max

N

 

4

Exist

Boolean

 

N

Check Constraint (‘0’, ‘1’)

 

10. Cameras and DVR Vendor List

Sr No.

Field Name

Datatype

Size

Nullable

Constraint

 

 

 

 

 

 

1

Vendor Id

Number

8

N

Primary Key

2

DVR Type Id

Varchar2

15

N

Foreign Key

3

DVR Type Name

Varchar2

max

N

 

4

Camera Type Id

Number

8

N

Foreign Key

5

Camera Name

Number

8

N

 

6

DVR Type Quantity

Varchar2

2

N

 

7

Camera Type Quantity

Varchar2

4

N

 

8

Company Name

Number

8

N

 

9

Content Name

Varchar2

10

N

 

10

Phone Number

Number

8

N

 

11

Email

Varchar2

8

N

 

12

Website Address

Varchar2

8

N

 

13

Exist

Boolean

 

N

Check Constraint (‘0’, ‘1’)

3.2 Relationships
The relationships between the classes are shown in the ENTITY RELATION DIAGRAM.

 

3.3 Complete Data Model