Case Study Provide a program to keep a peripherals devices store inventory. The store sells various items. For each items in the store, the following information is kept: item ID, item name, item category, number of pieced ordered, number of pieces currently in the store, number of pieces sold, manufacturer's price for item, the store's selling price, and the total inventory. The total inventory is the total selling value of all of the items currently in the store. The total number of items is the sum of the number of pieces of all of the items in the store. At the end of each week, the store manager would like to see a report.

Your program must include the menu driven, giving the user various choices such as checking whether an item is in the store, selling an item, and printing the report. After inputting the data, sort it according to the items' names. Also, after an item is sold, update the appropriate counts. Initially, the number of pieces (of an item) in the store is the same as the number of pieces ordered, and the number of pieces of an item sold is zero.

You may model your design based on the scenario given above. The quality of your system will be based on how much detail your system design as well as the level of completeness of your design and the actual system.

Additional requirements:

a)    Design and implement the functionality to allow the operation such as design, implement, test and document.

b)    The client system should have the following:

•                 Insert and modify data accordingly to show functionality of the system.

•                 Save data to the database.

Program requirements:

•                 You should implement validations and store the information to database.

•                 You would also need to submit a report detailing the development of the program. It should contain the design, source code and properly labelled sample screenshots of your program execution.

•                 All files must contain the following information: your name, student id, course, and date within comments (in the header) in the source code and also the report document.

•                 Your program should be compiled and executed using windows programming and SQL Server.

•                 You must follow the naming convention for your forms, controls and attribute names.

PART A - STAGE 1 DESIGN [20%]

•                 Your design should include the system's interface and functionality.

•                 You should present the use case diagram with justification.

•                 Your tables in the database should have primary keys and foreign keys where ever required.

•                 You should describe the design process with good justification provided to support your design approach. You would get very low marks if you simply dump the entire system design (diagrams) with no justification provided.

PART B - STAGE 2 DEVELOPMENT [60%]

The deliverables of this stage would be IMPLEMENTING and TESTING of your system. You are to ensure that you implement all functionalities and validations. The document should include your design (Stage 1) and source code, screenshots of outputs and the test plan. It should also include the user manual(guide) for the system at the last.

PART C - STAGE 3 DEMONSTRATION [20%]

The demonstration session enables the lecturer to access the originality of your work and test on your understating of the assignment.

Ask a new question

pur-new-sol

Related Questions