Read more comic bookstore database Submitted by: Jose Pires Submitted to: Dr. Shengli Yuan CS 4318 – Database Management System University of Houston-Downtown Purpose of Document This is a...

Database


Read more comic bookstore database Submitted by: Jose Pires Submitted to: Dr. Shengli Yuan CS 4318 – Database Management System University of Houston-Downtown Purpose of Document This is a requirements specification document for a database of comic book stores. Abstract: We plan to create a database that employees of the store can use to look through their current inventory to a comic, apparel, rented comic, renter status, and mangas and determine if they have any at their location. If there is any, it will be able to tell the employees how many issues are currently there, rented, or bought recently. Additionally, there will be functions to add and remove comics to help with new shipments and purchases. Each branch has a min of 2 staff, and a min of 1 for each type of inventory (apparel, comics, manga, rentable_comics, snacks, and action figures). Mission statement The purpose of the XYZ database system is to maintain the inventory of the comic book chain and facilitate shipments between branches as well as from publishers and other producers of merchandise that is sold at the chains. As well as help organize and maintain staff and branch data. Mission objective ● To maintain(enter update and delete) branch data. ● To maintain (enter update and delete staff data. ● To maintain(enter update and delete) data of comics at each branch. ● To maintain(enter update and delete) data of action figures at each branch. ● To maintain(enter update and delete) data of apparel at each branch. ● To maintain(enter update and delete) data on rented comics. ● To maintain (enter update and delete) renter status data. ● To maintain(enter update and delete) data on snacks. ● To maintain(enter update and delete) data on mangas. ● To perform searches on branches. ● To perform searches on staff data. ● To perform searches on the inventory of comics at each branch. ● To perform searches on the inventory of action figures at each branch. ● To perform searches on the inventory of apparel at each branch. ● To perform searches on rented comics. ● To perform searches on renter status. ● To Perform searches on snacks. ● To Perform searches on mangas. District manage r Store manager All branches Maintain Search x x x Their branch Maintain Search print x All staff Maintain Search x x their staff Maintain Search x x All comics Maintain Search X x Their comics Maintain Search X X All branch action figures Maintain Search X X their branch action figures Maintain Search X X USE CASES 1. Name: Searches all branches Actor/Users: District Manager, Store manager steps: a.The user requests a search of branches with highest rating All branch apparel Maintain Search X X Their branch apparel Maintain Search X X All Rentable_ Comics Maintain Search X X Their rented comics Maintain Search X X All renter status Maintain Search X X Their renter status Maintain Search X X All mangas Maintain Search X X Their mangas Maintain Search X X All snacks Maintain Search X X Their snacks Maintain Search