Consider the following situation. "The Head of Department of XYZ university allocates duties to members of teachis staff and others at the end of each academic year. One person (Teacher) is assigned to lecture each of the modules which are supposed to be available in the following year. Each teacher updates his/her course outline for the module assigned. The Course coordinator updates other parts of course outline and check the module entries produced by the teachers. The academic officer keeps the master list of all students and updates the mailing list of students taking different modules and send it to the course coordinator. Student provisionally registers for modules. The academic officer checks that every student registered for a reasonable set of modules." a) Predict the potential classes under the scope of this project? Also explain the reason of b) assumption. c) Show the purpose and scope of the project as per your own understanding? d) Predict attrībutes and methods that are essential in the classes explain the reason? e) Illustrate an appropriate class hierarchy.

Consider the following situation. "The Head of Department of XYZ university allocates duties to members of teachis staff and others at the end of each academic year. One person (Teacher) is assigned to lecture each of the modules which are supposed to be available in the following year. Each teacher updates his/her course outline for the module assigned. The Course coordinator updates other parts of course outline and check the module entries produced by the teachers. The academic officer keeps the master list of all students and updates the mailing list of students taking different modules and send it to the course coordinator. Student provisionally registers for modules. The academic officer checks that every student registered for a reasonable set of modules." a) Predict the potential classes under the scope of this project? Also explain the reason of b) assumption. c) Show the purpose and scope of the project as per your own understanding? d) Predict attrībutes and methods that are essential in the classes explain the reason? e) Illustrate an appropriate class hierarchy.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 16RQ

See similar textbooks

Similar questions

A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
DOMAIN CLASS DIAGRAM Note: The Domain CD includes only the class name, attributes, relationships, and multiplicities. DESIGN CLASS DIAGRAM Note: The Design CD includes everything in the Domain CD plus the attribute type, visibility, operations and operation type, controllers, interfaces.
You are the director of a summer camp who wants to create a program to register campers and counselors. The information you need from campers include: name age gender swim level (beginner, intermediate, or advanced) special diet (boolean) length of stay (one-week or two-week ) sleepover or day camper two daily activities (from an activity list below) The information you need from counselors include: name age gender activity area (from the same activity list below) Activity List each camper must choose two activities from this list one of the activities must be swimming, unless they are an advanced swimmer (swim-level) swimming boating tennis baseball basketball create a Camper class and a Counselor class create a camper.h file and a counselor.h file declare private member variables for each item of information needed from campers and counselors declare public member functions declare two constructors for each class one constructor that accepts values for each…
Question 3 Draw a detailed activity Diagram in draw.io and screenshot it for me. ( **Please take note is a detailed activity diagram) Scenario The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when…
List the changes needed to make the requirements change so a student can have more than one advisor and list the changes needed to make the requirements change so that you must store the year and the semester in which a student took a course and received a grade.
A company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A). Draw ER Model For the companyB). Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names.C). do you have any associative entities on your ERD? If so, what are the identifers for those associative entities?
A small training college has decided to extend and replace its existing database system. The project has received board approval and the required functional changes and additional requirements have been agreed with the users. A project manager has been appointed and has been allocated a project team of three database analysts, three development programmers and one tester, with selected users being made available for acceptance testing. An outline project schedule for the development and implementation phases has been drawn up. It includes the following tasks and related staff allocations. Task Description Duration (weeks) Staff A Define required new database functionality 4 Database Analyst DA1 B Define new data entry and update requirements 3 Database Analyst DA2 C Define new data analysis and report outputs 3 Database Analyst DA3 D Define database transfer rules 2 Database Analyst DA3 E Code and test extended database tables…
A company has a number of employees. The attributes of FEMPLOYEE include Employee io (identifier), Name, Address, and Birthdate. The company also has several prolects. Attributes of (PROJECT include Project ID (identfier), Project Name, and Start Date. Each employee maybeassigned tp one or more projects or may not be assigned to a project. A project must have at least one emplovee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project. A. Draw ER Model For the company B. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. C. to youhave any associative entities on your ERD? If so, what are the identifers for those associative entities?
You are commissioned by AAA Review Center to conduct a four hour review session among the teacher education graduates. You are assigned to discuss the topic, “Discontinuity of functions”. On a one whole sheet of paper, make a review material with all the concepts, examples and illustration about the topic on it
The Vegan Garden is a little restaurant that may be found in the tranquil village of Dawnsville. It has been five years since the eatery first opened its doors. At the moment, sales are recorded manually via the use of cash registers, and monthly sales reports and other corporate paperwork, such as information on employees and suppliers, are kept in dated filing cabinets. The owner of Vegan Garden has made the decision to develop an information system. He then went and sought the aid of a company that specializes in information technology in order to design an information system that would be suitable for the current commercial operations of the Vegan Garden.You have been given the responsibility of serving as the project manager for the creation of the Vegan Garden information system.As the project manager of the development project, it is your responsibility to advise the owner of Vegan Garden about the information system security issues that exist. Provide an explanation for ANY…
The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies. Q: Suppose a single relation “Movie” which contains all attributes of all…
Assume that the computer system has performed all required steps to get a program ready for execution. Describe in detail how the computer system will run the program, including the computer system components involved in each step. This query is not concerned with the procedures necessary to prepare the program for execution. Rather, describe the procedures required to execute the program.