Ask Question, Ask an Expert


Ask DBMS Expert

Home >> DBMS

Project Title: Computer Sales and Repair Store System – CSRSS

It is required to design a relational database system for a “realistic” application described below. This is followed by an implementation of the system in MySQL. The application is a two-tier system, which uses the Internet Explorer (IE) at the client side and http server with PHP parser at the server side. The system is expected to support all “representative” queries and transactions, and produce various desired reports. A schedule for the demos will be prepared and posted. The project report must be submitted at demo time.

Project Description

Use MySQL Database Management System to develop a miniature database application on Computer Sales and Repair Store. The application includes a collection of tables and a form-based user interface to insert, update, and retrieve information about various services of this store, which includes computer sales and upgrades/repairs (through replacing parts and/or installing various software). exs includes selling laptops and desktop computers, changing screens, keyboards, OS, power unit, anti-virus, upgrading main memory, hard disk, etc. There are a number of personnel working in this store each of which has a code when they login and record their activities. For each service or part provided there is a default cost, which is recorded in the system but could also be over written by the clerk for complications that may arise during the service. Depending on their seniority and agreement with the company (who owns the store), there will be different percentage of commissions. For instance clerk 1 may have agreed to collect 50% of service fees, so if clerk 1 changes a hard disk, if the hard is $80 and replacing is $30, then clerk 1 gets 50% of $30 and the company gets $15+$80 (assuming all parts and software are provided by the company).

Requirements Specification

You are required to develop a database system that will hold at least the information about the following entities and relationships:

• Details on sales and services provided: Basic information on all computers, parts and software, the purchase date and amount, etc. The store manager can check details of activities of each employee in terms of different services he/she provided, the dates, amounts as well as store revenue and each technician’s shares. For computers/laptops brought to the store for repair more than once, a history of previous service activities on the computer.

• Details on employees: Records of information on each employee, date of employment, his/her seniority, weekly, monthly, and annual payments.

• Inventory Details: The system is expected to contain complete and up-to-date information of computer and parts present or sold, with records of date, and amount purchased/sold.

• Details on Online Sale: The store is also involved in online computer and laptop sales, say through EBay. Extensive report of online sales, locations delivered (City, Province, Country) and revenues. When these sales are done through one of the employees, there is an x% commission for that employee find outd in his/her income. The percentage x is recorded in the system for each employee and the default value is 50%.

These are the minimum requirements in your database. It is expected to discuss this application among yourselves as well as talk to people knowledgeable in the domain to enrich the application and make it more realistic.

Implementation Details:

Functions and Reports Design and implement the user interface using HTML and PHP for the required queries alluded in the above description of the system and its requirements. Details on how to use PHP and HTML with MySQL will be provided by the lab instructors. Populate your tables with enough data to show the functionality of your system (10 to 20 tuples per table on average.).

The system should support at least the following functionalities through its interface:

1) Search for a part/software using the item’s name or code. This query can be submitted by the store manager and/or any employee.

2) Update personal information – Insert and/or update employees information.

3) Given an employee, list his service history from a given date to a given date, sorted by date. For each service the amount of commission paid to the technician.

4) Given a date, list all services provided by all technicians. This is useful to trace all services provided on a specific computer/laptop since the given date. The default date is the beginning of the year.

5) Generate the list of parts and softwares together with their frequency of use. This helps identify parts which are used less frequently, thus allowing to spend money on more frequently used items.

6) Details and total revenue through online sale and in-store services (sales and repairs). After sometime, the manager wants to know whether focusing on one of the two (online or in-store) activities would be more beneficial.

1. Develop an E/R diagram for the entity sets and relationships described above. Determine the attributes and the multiplicity of the relationships.
The design should be as compact as possible without sacrificing the required objectives. Make sure you state clearly any reasonable assumption made in your design, which is not specified in the requirements specified above.

2. Convert your E/R diagram into a relational database schema. Make necessary refinements to the schema, if possible. Identify various integrity constraints such as primary keys, foreign keys, functional dependencies, and referential constraints. Make sure that your database
schema is at least in 3NF.

3. Provide implementation details of your database system in MySQL with a suitable user interface using HTML and PHP.

Your project must include details on:

• The design of the DB using an E/R data model.

• Its conversion into a relational model satisfying at least 3NF.

• The user-interface for each supported application and reports.

• A sample session for each application (user guide).

• An installation guide.

• All codes.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M92031

Have any Question? 

Related Questions in DBMS

Database management systems assignment-overview-for this

Database Management Systems Assignment- Overview- For this assignment you will implement and query a database from a supplied ER Diagram and Schema.  You will be required to write the SQL statements to create the databas ...

Home libraryisbntitleauthor Home Library I SBN Title Author LastName Author_FlrstName

Home Library I SBN Title Author LastName Author_FlrstName Publisher Date Edition Media 369852 Cosmos Sagan Carl Random House 1980   Book 741258 No Secrets Simon Carly Elektra 1972   CD 654789 Symphony No 3 Dur Eroica Op ...

Upload your final project code and your presentation upload

Upload your final project code and your presentation. Upload all of your code in one large text file that has the .sql extension. Be sure to identify each section of code so that the reader will know what it does. All co ...

Your assignment should be submitted in a single word doc

Your assignment should be submitted in a single Word doc (.doc or .docx). It should include your scenario diagram for Problem 1, and your Ruby source code for Problems 2 and 3. Contact me or post to our discussion board ...

List the different types of locks used by dbms systems and

List the different types of locks used by DBMS systems and explain how they differ from each other. Additionally, suggest the suitable scenario for each of them. 400 to 500 words, at least 4 references with one website r ...

Database reflectionuse the attached database and associated

Database Reflection Use the attached database and associated sheets to review and to make sure the forms are working. Review your project; make sure that all the forms are working. Write a one page report on how you coul ...

Database design and use group assignmentassignment

Database Design and Use Group Assignment Assignment Description - In this assignment you will use your normalized "City Jail" database you have created in your assignment one. You will form a group (2-3 students) and imp ...

Assessment item 1taskthe fermoy house databasethe owners of

Assessment Item 1: Task The Fermoy House database The owners of Fermoy House, a Bed and Breakfast guest house in the Blue Mountains of NSW, have approached you to build them a database to help them run their business. Fe ...

In general my report talks about the database management

In general, my report talks about the Database management system. But I want to a specific topics of it in 3 pages. The topics are: 1. Comparison between File approach and Database approach. 2. Advantages and disadvantag ...

Stored procedures and stored functions - major assessment

Stored Procedures and Stored Functions - Major Assessment Task Background You are to create tables to store product and customer data. You will create a number of stored procedures and functions (SPFs) to insert / update ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate