UTAS offers different online courses to the community members in Shinas. A community member must register in the system to attend the course. Department Coordinator will receive the registration details. He will check for the availability of the course. If the course is available, then, he will assign the registration ID. Then he will send the registration details to the Course Coordinator; otherwise he will send "course not available message" to the community member. The Course Coordinator will access the community member details. Then he will add the member to the class list and will update the remaining seats available in that course simultaneously. After completing both activities, he will send course schedule to the Department Coordinator. The Department Coordinator will update the registration status and will send the schedule to the registered members. Analyse all aspects of the scenario above and prepare the CRC card for the Department Coordinator class.

UTAS offers different online courses to the community members in Shinas. A community member must register in the system to attend the course. Department Coordinator will receive the registration details. He will check for the availability of the course. If the course is available, then, he will assign the registration ID. Then he will send the registration details to the Course Coordinator; otherwise he will send "course not available message" to the community member. The Course Coordinator will access the community member details. Then he will add the member to the class list and will update the remaining seats available in that course simultaneously. After completing both activities, he will send course schedule to the Department Coordinator. The Department Coordinator will update the registration status and will send the schedule to the registered members. Analyse all aspects of the scenario above and prepare the CRC card for the Department Coordinator class.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

An authorized of an information system is attempting log in, but has forgotten the password for his account. After a certain number of failed attempts, an IDS reports this incident. Name the type of result the IDS should generate, and briefly explain why that is the appropriate type.
Proxy server reduces the response time for client request – justify the statement.
Please answer it fast
create a flowchart in applying for a job.
An ATM allows a customer to withdraw a maximum of $500 per day. If a customer withdraws more than $300, the service charge is 4% of the amount over $300. If the customer does not have sufficient money in the account, the ATM informs the customer about the insufficient funds and gives the customer the option to withdraw the money for a service charge of $25.00. If there is no money in the account or if the account balance is negative, the ATM does not allow the customer to withdraw any money. If the amount to be withdrawn is greater than $500, the ATM informs the customer about the maximum amount that can be withdrawn. Write an algorithm that allows the customer to enter the amount to be withdrawn. The algorithm then checks the total amount in the account, dispenses the money to the customer, and debits the account by the amount withdrawn and the service charges, if any. (9) Submit your answer to dropbox.
Determine which commands are used for what purpose and use them efficiently.
Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
In a few phrases, describe what a nested procedure call is.
Fordley Car Park is open between 7am and 9pm every day. They charge £2.30 per hour with a minimum fee of one hour and a £2 overnight charge for stays between 9pm and 7.30am. Payments are made at the end of a visit. The car park is also used by resident and business permit holders on the basis of annually renewable membership. All new memberships are registered via the Fordley Car Park website or by completing a form which can be picked up from the car park attendant. Recently Fordley has invested in a paperless attended smart parking system that scans car registration numbers as cars drive through the entrance gate. To ensure that a reading has been captured, the gates only open when a valid registration is read. Exit gates also have a camera which scans the car registration number and will open automatically unless payments are outstanding in which case the payment can be made at the attendant kiosk without leaving the car. Members whose membership has expired can also pay for the…
Video-Rental LTD is a small video rental store. The store lends videos to customers for a fee, and purchases its videos from a local supplier. A customer wishing to borrow a video provides the empty box of the video they desire, their membership card, and payment – payment is always with the credit card used to open the customer account. The customer then returns the video to the store after watching it. If a loaned video is overdue by a day the customer's credit card is charged, and a reminder letter is sent to them. Each day after that a further card is made, and each week a reminder letter is sent. This continues until either the customer returns the video, or the charges are equal to the cost of replacing the video. New customers fill out a form with their personal details and credit card details, and the counter staff give the new customer a membership card. Each new customer's form is added to the customer file. The local video supplier sends a list of available titles to…
Dissect how Disconnected mode sends a query text to the server.
ShopIt is an online merchandise provider that charges their shipping fee based on the number of items purchased. If a single item is purchased, the shipping charge is $4.99. When customers purchase between 2 and 5 items, they are charged the initial $4.99 for the first item and then $3.99 per item for the remaining items. For customers who purchase more than 5 items but less than 15, they are charged the initial $4.99 for the first item, $3.99 per item for items 2 through 5, and $3.49 per item for the remaining items. If they purchase 15 or more items, they are charged the initial $4.99 for the first item, $3.99 per item for items 2 through 5, and $3.49 per item for items 6 through 14, and then just $1.99 per item for the remaining items. Allow the user to enter the number of items purchased. Design the logic of the program using pseudocode. Display the number of purchased items and the shipping fee. The program will continuously run until the user enters zero for the number of…