You work for a Surveillance Video Cameras Installation& Maintenance Services shop, your company also repair and install security cameras (Surveillance Cameras) for business. You are tasked with developing a software solution to support the company’s Products and Services Tracking. The company is growing and in much need for an application that keep tracks of Their products and services. The main products the company offers falls into categories as follows:
- Surveillance / Security Cameras
- Digital Video Recorders (DVR)
- Surveillance System Accessoires (cables, electrical boxes, Ethernet cables, etc.)
The main services the product provide:
- Security camera installation
- Surviellance system maintenance
The security cameras offered are of different types (Bullet cameras, Dome, C-Mount, Infrared, PTZ / Speed Domes, Wireless, Network / IP, Micro Security) we should be able to add additional types. Each camera type should this specification:
- IR LED: ￠8X36PCS
- IR LED working distance: 50M
- Water resistance: (yes, no field)
- Lens: 4-9mm Manual Zoom Lens
- DC12V/AC24V double voltage add USD4
The DVR systems also come in different configuration (4 Channel DVR, 8 Channel DVR and 16 Channel DVR). We should be able to add additional configuration. Each DVR type comes with its own specification such as:
- Compression Format (H.264, etc.),
- Resolution 720 x 480 ( NTSC ), 704 x 576 ( PAL )
- Playback resolution：4 x D1
- Real time recording support: CIF:352×240 with 240 Fps (NTSC); 352×288 with 200 Fps (PAL)
- USB port: a number default is 1
The security system accessories need to be stored as well and need to have the ability to add / remove / update new accessory into the list.
Each product offered has a vendor and quantity at hand associated with it. Vendor list need to be configurable and we need to track basic vendor information (company name, content name, phone number, email, website address, etc.).
The main goal of the application inventory tracking and management. The information can be easily accessed when needed along with data entry views that enable any one in the company to enter the information. There shall be one security level.
- The tool should maintain a small repository of project data. This does not have to be a relational database management application (you can use flat files)
- The ability to add/update/delete all information is required.
- Numeric key fields should be automatically generated. Such as customer ID.
- Security is required. Only one level of security.
- The system must respond to all requests within 10 seconds.
- A web-based solution would be nice, but not required.
- The use of a relational database is not required. You can use flat files for example.
- The following reports are required:
- List all Security Camera types available along with quantity and vendor information
- List all Security DVR types available along with quantity and vendor information
- List all vendors.
- List all Accessories
Click here for Surveillance Shop Questions.
Video Recorders (DVR) and Camera Types
- 4 Camera DVRs
- 8 - 12 Camera DVRs
- 16 - 24 Camera DVRs
- 32 - 64 Camera DVRs
- Mobile DVR
- Outdoor DVR
- VR Series DVRs / IP Cams
- VR Series Elite DVRs
- more here
Security Camera Types
- C-mount camera
- Day / night camera
- Dome camera
- Pan-tilt-zoom (PTZ) cameras
- Pin-hole camera
- Waterproof cameras
- Weatherproof cameras
- Bullet Dome
- Infrared PTZ / Speed Domes
- Wireless Network / IP Micro Security
- more here
CCTV Surveillance System Accessories
- Infrared Lighting
- Power Supplies
- Surge Protectors
- AC adapto
- AES- Auto electronic shutter
- CAT5- Category 5 (cable)
- Mounting bracket
- Plug and play cable
- Power supply
- POE- Power Over Ethernet
- RG59 (common coax cable)
- G59 siamese cable
- click here for defintions and more