Computer Science Projects

Problem Statement: McNeese bookstore would like to provide online shopping service to students starting next semester. Students will be able to buy stuffs from the following categories: (1) books; (2) office supplies; (3) snacks; (4) cloths; (5) sport equipment. McNeese bookstore hires you to design a database as part of the backend server for the online service. Here are some of the basic system requirements: There are at least 20 items under each category The database needs to maintain the details of stocks such as their id, name, quantity, and category, etc. The database needs to maintain the details of customers such as their name, address, id, or payment information, etc. The database needs to be created by using MySQL, and SQL language. Some general functions in SQL language (such as how to search to an item, how to modify the quantity, etc) should be provided to McNeese bookstore as APIs so that customer can use them in the future. Get Project Solution by contactin...

Monash Library Services (MonLib) The local Monash Municipality maintains several libraries for its residents across the municipality. For each branch Monash Library Services assigns a branch code (an incremental number for each branch with the first branch using a code of 100). The branch name, address and contact phone number are also recorded. Each branch is assigned a manager. Due to the small size of some of the branches a particular manager may manage several branches. Each manager is assigned a manger id. Monash Library Services record a managers name and contact phone number. All managers are assigned one particular branch as their home branch. Monash Library Services maintain records of current loans of books to borrowers. Each borrower is identified by a borrower number and each copy of a title by a barcode number (the library may have more than one copy of any given title). When a borrower first registers to borrow books the branch where they register is recorded as their...

Practical Work Week 2 In this module, you are required to design and develop a database using MySQL Workbench. This week you should: formulate a database project proposal together with one of your classmates. This proposal will be due for submission on Moodle in week 3. You are also required to submit a hard copy of your proposal in your practical class. you may use MySQLWorkbench on the college machines or install the application on your own laptop. Please note: The proposal that you submit will need to support a database with minimum of 15 tables so it is important that you choose an idea which will give you the scope for such a database design. You should use your practical hours to ask for advice on choosing a suitable idea. Practical Work Week 3 At this stage you should: use the Sakila example provided with Workbench to familiarise yourself with the operation of the DBMS. create a complete ER model in Workbench for your team project. (Min. 15 tables) create a dat...

The company has 7departments: Sales, Finance, HR, Support, R&D, Design and IT. There are 50 employees within the various departments.  The company has some large clients, including Sony, HP, Dell, Apple, Novell, Oracle and Sun.  The company products include 5 different PCI components, 3 different infra-red scanners and10 different Bluetooth devices.  Salary and sales information should be in the database as well. Once the database has been created, you need to pull relevant information for Management. Management would like an overview of sales between 10 000 and 30 000 and also between 40 000 and 200 000.  They also want to know which companies are purchasing products for more than 250 000 per month and which salesmen are linked to those clients. This database is very important to the company and therefore you need to ensure that there is redundancy. This means that the company needs at least 1 Master database server and three slave servers. Since the co...

The Voice London Show Setup. In Part 2, based on a given ER diagram and a set of requirements, you will implement a relational model for a television talent show named TheVoiceLondon. Then, you will have to perform different data manipulation and retrieval operations on the database. On KEATs you will find a .zip containing template SQL files to edit for your Part 2 submission. Requirements. A television channel has decided to create a simple database to register payment information about its most successful show ‘TheVoiceLondon’. In this show, there are contenders that compete to represent the UK in Eurovision. These contenders are coached by famous artists (namely the coaches). Contenders can be formed by a group of participants or a single participant. Both coaches and participants are paid based on the number of shows they attend. For each coach and participant, the database sores their id, name surname, date of birth, phone, gender and daily salary. For each contender, the d...

Scenario: You are the database designer and developer for a donut shop that wants to create a smartphone application where customers an order donuts. First, you will design a normalized entityrelationship (E-R) logical database model to store data related to the customer, donuts, and donut order. Next, you will create four tables with primary and foreign keys that are derived from your ER model. Once the tables have been built, then you will create views and indexes to protect and fine-tune query performance. You will populate each of the tables with sample data. Finally, you will create both a simple “select-from-where” (sfw) query and a complex join query to produce meaningful reports on individual donut orders and summaries to determine which donuts sell the best. Requirements: A. Construct a normalized model to represent the donut shop smartphone application database that supports the scenario above by doing the following: Using the attached “Sales Order Form” (unnormalized ...

Background  Real-world databases are typically many orders of magnitude larger, in terms of numbers of relations, and the size of each relation. This impacts a crucial aspect of database usage, ‘performance’ (basically, how fast queries are processed). Your practical task will be to download such a database, and use it to learn more about real databases. You are going to download the ‘Mondial’ database, which carries information about the countries of the world. This is supposed to be based on the CIA’s World Fact Book among other sources. Go to this website: www.dbis.informatik.uni-goettingen.de/Mondial/ Find the paragraph entitled ‘Generating the Database under MySQL’ and click on each of the following links. www.dbis.informatik.uni-goettingen.de/Mondial/OtherDBMSs/mondial-schema-mysql.sql www.dbis.informatik.uni-goettingen.de/Mondial/OtherDBMSs/mondial-inputs-mysql.sql You do not download the data in the database base directly, but rather you download statements in t...

Database Requirements You have been hired by a nation-wide fitness company named Fitness4All. Fitness4All has gyms in different locations and offers different types of memberships to customers. Customers can also purchase different fitness lessons and personal training sessions. The company wants to utilize a DBMS to track the sales of classes and memberships. In addition, Firtness4All would like to start a customer loyalty program called the SuperFitRewards. Members who sign-up to SuperFitRewards can get offers on free classes! This also will allow Fitness4All to store data on customer purchases for his Data Science team to analyze. Here are the specifications for the database requirements: Fitness4All has gyms in different locations across the country. All of these gyms have a gym suite and they may have a swimming pool. Each gym has a unique identifier and the date in which the gym opened. Customers can become members of any of these gyms. In particular, there are three types...

Bounds Job Opportunities (BJO) Bounds Job Opportunities (BJO) is an organisation which tries to match people seeking new job opportunities with companies offering employment prospects. BJO have several offices in major cities in the Midlands. Many companies prefer not to advertise vacancies themselves, instead using an agency for the major part of their recruitment. Thus such agencies as BJO place advertisements in the most appropriate websites and newspapers. Each advertisement includes details of one or more jobs. Where a number of jobs are listed in a single advertisement, the vacancies are with a range of companies, rather than each advertisement listing the opportunities available with a single company. BJO operates in a variety of ways. Companies register with BJO (including their name address etc.), notify them of job vacancies and supply a job description for each. Each job description is analysed and the key requirements, such as preferred age range of applicant, skill and ...

Context A tour management agency runs concert tours.  It sets up tours by bands.  On a tour, a band gives concerts at venues on various dates. Only one band goes on a tour, and a band goes on only one tour at a time.  Tours have names. A band has musicians as members.   A band also has a music style, such as “heavy metal” or “folk”. There are several tour dates on a tour.  Each occurs at a venue, on a particular date. At each date, a certain amount of money is received in ticket sales. Each venue has a cost for hiring it.  Each concert yields a certain amount from ticket sales.  The difference between the cost and the ticket sales is the profit on the concert. What a Database will be used for? The management agency wants a database about its business.  It wants to be able to find out such things as which tours it has arranged.  (Assume that all tours have finished - covering tours that are still going on is an easy extension, b...

Project Introduction Thank you for your application for the role of Database Administrator (DBA) at OurCompany Inc.! We are currently reviewing applicants and would like to congratulate you on making it past the first round of screening. As part of our company’s hiring policies, we require that applicants for this role submit an assessment of their competencies. The assessment will comprise of the following deliverables, to be produced and returned to OurCompany within 48 hours of issuance; Database Analysis and Design - ERD During your role as DBA you will be required to perform requirements analysis to determine what type of information needs to be stored, and understand the operational needs of the database. For this assessment we have provided you with a transcript of an interview with a client, found in Appendix A. You will need to read this transcript and synthesize the needs of the database based on the client’s responses to the interview questions. Based on your underst...

Bank Corp Business Requirements BankCorp Ltd. offer Wealth Management and Investment Services to its Personal and Corporate clients. Currently, data is stored in a number of systems across the company. This leads to “double keying” and as a result inefficiencies and errors. They want to create a single database to consolidate all these details into one single source. They do not have any IT staff and they do not have the space or ability to look after any infrastructure on premise. They want you to design and develop the database only. Any data migration tasks will be taken care off in a future different project. The data model must be designed to meet 3NF (Third Normal Form) requirements. In terms of the key entities they have given you the following list: 1 Customers 2 Accounts 3 Securities 4 Associations A customer can have many accounts and an account can be secured by many securities. A customer can be associated to another customer in the bank e.g. a Property Developm...

Project Description This project came about due to a growing need for the members of Rosslare Football club to obtain information on match fixtures, results and for general club information and announcements. Since the introduction of junior teams, parents and members have requested more information regarding the club. The new system will also allow members and non-members to purchase club merchandise and to make donations to the club. The club chairman and the committee will oversee that all objectives and they will ensure they are met. Functional requirements The main functions of the new proposed system are: Member registration and login Inserting, deleting and inspecting members details Inserting and amending match fixtures, results and club details Altering system passwords High-Level Requirements The new system must include the following: Ability to allow both internal and external users to access the application without downloading any software Ability to i...

The project for database management will be to build an e-commerce database. The project is to be done in small groups and is due by the last day of classes. Use Amazon as an example e-commerce site and try to replicate the features of this site in your database (ie. should include features for users (buyers & sellers), products, reviews, categories, orders, etc.) You may need to create an Amazon account to explore the functionality of the website and to see what kinds of information they store for users and products. The deliverables for this project are as follows; A complete ERD, fully labeled, for the e-commerce site. You may include previous drafts of the ERD with notes and annotations explaining your process. I encourage teams to include a brief text explaining their process and design choices. A data dictionary to accompany the final ERD. The data dictionary should fully explain the details of the ERD, and be reflected in the subsequent script files.  A text file ...