Develop a simple MIS (Management Information System) that consists of asimple database (a text file). The system manages to dynamically inputrecord/data into the database. The data from the database can be sorted,searched and updated. User also should be able to add new records/data,remove any data and etc.Here are some ideas of MIS that can be developed:1. Hotel reservation system.2. Students management system.3. Payroll management system.4. Bus/Railway/Plane ticketing system.5. Clinic record management system.What should you do?1. Plan your group project - What MIS that you wanted to develop? Who isthe user? What is the flow of the system?2. Use only notepad (a text file) as your simple database.3. The system that will be developed must use a linked list structure.4. Use any sorting techniques to sort your data.5. Use any searching techniques to search for a data.6. Develop a user friendly and efficient system.7. The development of the system must use C++ and text file only for thedatabase.8. All programs must be documented in a simple report.

Develop a simple MIS (Management Information System) that consists of a simple database (a text file). The system manages to dynamically input record/data into the database. The data from the database can be sorted, searched and updated. User also should be able to add new records/data, remove any data and etc. Here are some ideas of MIS that can be developed: 1. Hotel reservation system. 2. Students management system. 3. Payroll management system. 4. Bus/Railway/Plane ticketing system. 5. Clinic record management system.

Develop a simple MIS (Management Information System) that consists of a simple database (a text file). The system manages to dynamically input record/data into the database. The data from the database can be sorted, searched and updated. User also should be able to add new records/data, remove any data and etc. Here are some ideas of MIS that can be developed: 1. Hotel reservation system. 2. Students management system. 3. Payroll management system. 4. Bus/Railway/Plane ticketing system. 5. Clinic record management system.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Similar questions

Create an ER diagram for the following requirements:You are asked to design a database to store music album information. A simplified set of requirementsare provided below.- A music album has a title, year of release, total running time, one or more artists, and list ofsongs.- Each song has a lead artist and may have a list of additional artists. Each song has a list of otherassociated people such as mixer, mix engineer, keyboards, guitar, etc. Each song has a genre,running time, and lyrics. Each song can be associated with many albums, but needs to beassociated with at least one.- Each person has a first name, last name, and nickname.
Project Synopsis: DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…
A record company wishes to use a computer database to help with its operations regarding its performers, recordings and song catalogue.• Songs have a unique song number, a non-unique title and a composition date. A song can be written by a number of composers; the composer’s full name is required. Songs are recorded by recording artists (bands or solo performers). A song is recorded as a track of a CD. A CD has many songs on it, called tracks. CDs have a unique record catalogue number, a title and must have a producer(the full name of the producer is required). Each track must have the recording date and the track number of the CD.• A song can appear on many (or no) CDs, and be recorded by many different recording artists. The same recording artist might re-record the same song on different CDs. A CD must have only 1 recording artist appearing on it. CDs can be released a number of times, and each time the release date and associated number of sales is required?
Specification Suppose you are asked to design a club database system based on the _following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees. Question Draw an E-R diagram for the system according to the above description.
A company sells toys by mail order. The company already has a product database, with a simple web interface, so that customers can get information about toys and prices. Currently, customers place orders by mail or by telephone. The company decides to create a system for selling toys online. The system will have three components: a product database, a customer database, and an ordering system. The plan is to develop the system in two phases: Phase 1 The product database will remain unchanged but the web interface will be replaced by the ordering system. A fully featured version of the ordering system will be developed. Every effort will be made to create an ordering system that will need little or no modifications in Phase 2. A simple version of the customer database will be developed. Page 3 of 4 Phase 2 A new product database will be created. Major enhancements will be made to the customer database. Minor changes may be made to the ordering…
Draw the Level 0 and Level 1 Data Flow Diagram for the Omantel Billing System Scenario: The teacher uploads the eLearning question, which is then saved in the QUESTIONS database, and informs the students that the quiz is now available for them to take. When taking the quiz, the student will be randomly assigned questions from the QUESTIONS database. All of the student's answers will be saved in the ANSWER database. The system will automatically mark the quiz by accessing the student answers from the ANSWER database and the correct answer from the Question database, after which the system will notify both the teacher and the student of the results.
Design and draw an ER diagram that captures the information about the university. Consider thefollowing information about a university database: Professors have an SSN, a name, an age, a rank,and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a startingdate, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degreeprogram (e.g., M.S. or Ph.D.). Each project is managed by one professor (known as the project’sprincipal investigator). Each project is worked on by one or more professors (known as theproject’s co-investigators). Professors can manage and/or work on multiple projects. Each projectis worked on by one or more graduate students (known as the project’s research assistants). Whengraduate students work on a project, a professor must supervise their work on the project.Graduate students can work on multiple projects, in which case they will have a (potentiallydifferent) supervisor for each one. Departments have a…
1. Draw the context diagram or Level 0 DFD for the following case/scenario. “The purpose of the SALALAH acres real estate system is to assist agents as they sell houses.Sellers contact the agency, and an agent is assigned to help the seller complete a listing reqeuest.Information about the house and lot taken from that request is stored in a file. Personal informationabout the sellers is copied by the agent into a sellers file.When a buyer contacts the agency, he or she fills out a buyer request. Every two weeks, the agency sendsprospective buyers area real estate listings and an address cross reference listing containing actual streetaddresses. Periodically, the agent will find a particular house that satisfies most or all of a specificbuyer’s requirements, as indicated in the buyer’s requisrements statement distributed weekly to allagents. The agent will occasionally photocopy a picture of the house along with vital data and send themultiple listing statement to the potential…
Draw a Context-Level and a Diagram-0 for the system activities described below. Temp Job Finder is a company that specializes in placing employees in businesses for short periods of time. This is how they handle their work: a. Businesses telephone the company to request temporary employees. The requests are used to create an Employment Request record. If the business requesting the temporary employee is not on the Employer Master file, a record is created for it. b. Employees are selected to fill the temporary positions based on employee qualifications and availability. The Employee Master and the Employment Request files are compared to identify all qualified candidates. c. Contracts are sent to the selected temporaries. Information is printed from the Employee Master, Employer Master, and Employment Request files. d. Returned contracts are used to update the Employee Master file. The Employment Request file is updated with scheduling and personnel information.
There are two types of objects: scripts and stored procedures. How do their differences manifest themselves? Different people have different roles. When possible, it is best to install Stored Procedures through the database.
Draw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.
Design a database to store the marketing information that allows business users to generate the reports related to Activities, Campaigns, Programs and Cost for marketing purpose. For example, this database should provide the proper data if the business wants to find out the cost of each activity, list the activities for each campaign and Programs, etc. Here are the relationships between Activities, Campaigns, Programs, and Invoices: a.A Program may be related to one or multiple Campaigns. b. A Campaign may be related to one or more Programs. c.An Activity only belongs to one Campaign. d. One campaign can include many activities. e. An Invoice includes the cost for one activity. Each activity has its own invoice.