A social recreation club has a system to keep track of club members, committees and activities. Each club has a registration number and a title. Several members form committee. Members are male and females. Each committee has a name, a unique number and a date, which the committee has formed. The system stores the members' unique identification number, name, address, gender, birth date and club joining date. The club forms committees for different activities. A committee controls and organizes a number of activities, each of which has a unique name, a unique number and description of the event. An event has event ID and description of the event. An activity may consist of several events. Committee publishes many online advertisements about the activities. Advertisement details are ID and a title. Draw the ER diagram to represent the above scenario

A social recreation club has a system to keep track of club members, committees and activities. Each club has a registration number and a title. Several members form committee. Members are male and females. Each committee has a name, a unique number and a date, which the committee has formed. The system stores the members' unique identification number, name, address, gender, birth date and club joining date. The club forms committees for different activities. A committee controls and organizes a number of activities, each of which has a unique name, a unique number and description of the event. An event has event ID and description of the event. An activity may consist of several events. Committee publishes many online advertisements about the activities. Advertisement details are ID and a title. Draw the ER diagram to represent the above scenario

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 6PE

See similar textbooks

Similar questions

In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write a Nassi-Shneiderman diagram that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.
In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write an algorithm in pseudocode, a flowchart and NS diagrams that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.
Subject: Disrete Structures A landline Telephone number contains 7 digits. How many Landline numbers can be formed if the first number must be a 4, 6 or 2. The second and third number must match each other and the last digit can be anything from 1 to 5.
The following is a sample report from a child clinic. It shows the days and treatments for visits to doctors at the clinic. A mother takes her child, sees a doctor and the doctor administers some treatment. There are couple of things you should assume: The mother’s name is unique. a mother won't have more than one child with the same name the doctor's surname is unique a treatment code is unique treatments are specific to doctors, eg 101 is only ever given by Johnson Surname First Name Town Age Child Doctor Date Treatment Smith Jane Coventry 30 Rebecca Johnson 27.3.04 101 Brian Clarence 30.5.04 209 Robert Johnson 10.1.88 101 Brown Beryl Rugby 28 Alan Clarence 30.4.04 214 Sarah Johnson 29.5.04 101 Sarah Clarence 12.1.04 321 Jones Fiona Kenilworth 34 James Clarence 30.4.04 322 Jenny…
Using C LANGUAGE build a system to manage patients’ data in a hospital. The hospital patient management system stores specific information in the form of health record to keep track of the patients’ data.Your program should read the information from a file called“patients.txt” that should be on the following format:Patient Name#Gender#Date of admission#Date of birth#Illness#Address (City)#Blood typeExample of data input:Abed Mukhles#M#2212019#01012000#EarInfection#Jenin#O+Nadia A. Ali#F#01102020#05101970#COVID-19#AlBireh#A1. You are required to implement a program to help creating the system byincluding the following operations of an AVL tree:• Read the file patients.txt and load the data (i.e., AVL Tree).• Insert a new patient from user with all its associated data.• Find a patient and give the user the option to update the informationof the patient if found.• List all patients in lexicographic order with their associatedinformation.• List all patients that have the same illness.•…
Student Companion ™ is your personal academic guide that provides the following basic information for each course while a student at the USC. Courses done, grades earned, Course outline attachments, course notes etc.This is a simple application to keep track of each course you are doing/have done and can serve as a personal test timetable for the course which has final quiz, keep track of your courses that have etc. The concept is like a personal check sheet system blended with a simple quiz timetable. This also solves a problem that often shows up when students have completed their program and need to revert back to data pertaining to their academic life from their viewpoint. Please note this does not replace a transcript, which is an official University Document. 1. Create a Class Diagram of at least six (6) major entities for your application. For entities with a large number of attributes you are allowed to limit your attributes to a max of six (6). All operations within each class…
A Service Station has multiple branches and they provide basic services such as Oil Change and Car Wash (Assume there is one type of Oil Change and Car Wash is available). All vehicles are registered at the service station before they can be serviced. Create a GO program that will send a promotion (or reminder) to the vehicle owner for oil change 6 months since the last oil change. Demonstrate: Given a date, generate a report showing customer information, car, type of service and last date of service. Given customer id, generate a report showing details of last coupon notification for each of the service. Hint: Create packages for Dealer, Technician, Service, Customer, ServiceTransactionHidtory, CouponNotificationHidtory, etc. Make sure the data can be stored in the text file (Comm Separated File or CSV is recommended) Allow all operations on each of the operations such as add, update, delete and search. Load the data into array or slice object from your data files when you start…
(Practice) You’re responsible for planning and arranging the family camping trip this summer. List a set of subtasks to accomplish this task. (Hint: One subtask is selecting the campsite.)
In C Programming Language Patient Following System1) Define a struct included patient number, name, age, and disease information.2) Main menu of the program include the following operations:◦ create a patient file with 100 empty records.◦ Insert a new patient record.◦ Find and retrieve patient information.◦ Delete a patient record.◦ Modify a patient record.◦ List all patients information. I need more information for solution.
Python Programming Problem: Simple Soccer Point TableThe programmer will design a simple point table lookup and update application. The table contains some basic information: team_name, match_played, win, draw, loss, point and rank. Design Solution:1. English Premier League is a prestigious soccer league. Here is the result of its one session. Man. City|38|32|2|4|98|1Liverpool|38|30|7|1|97|2Chelsea|38|21|9|8|72|3Tottenham|38|23|2|13|71|4Arsenal|38|21|7|10|70|5 2. Hypothetically, you have been assigned to design a simple lookup software for prestigious ‘English Premier League’ from a given point table. The point table contains team_name, match_played,win, draw, loss, points and rank. 3. The input file, ‘previous_result.txt’ has been provided to you above the top 5 teams in 2018-19 session. Your software needs to be able to search and update the point table based on user input. For example: The first time Chelsea played 38, the second time it changed (based on user input) to 40 and so…
You are required to develop an appropriate data structure which keeps the record of Sent items ofEmail.
IN C LANGUAGE A well-known showroom allows managers to keep track of how many appliances are available or have been sold. Ask the user to input the following information for n number of appliances in the showroom: Code, Price, Status(Available/Sold) Create the following files: 1. “available_appliances.txt” that displays all the information of appliances available in the showroom. 2. “sold_appliances.txt” that displays all the information of sold appliances.