What is a database used for quizlet?
|
Show Recommended textbook solutionsPython for Everyone2nd EditionCay S. Horstmann, Rance D. Necaise 730 solutions Computers And Information Technology Tex1st EditionRobert R Pagano 411 solutions
 Python for Everyone Interactive Edition2nd EditionCay S. Horstmann, Rance D. Necaise 730 solutions Python for Everyone2nd EditionCay S. Horstmann, Rance D. Necaise 730 solutions
Terms in this set (33)Students also viewedOther sets by this creatorVerified questions
computer science Verified answer
computer science Verified answer
computer science Verified answer
computer science This program should be designed and written by a team of students. Here are some suggestions: - One or more students may work on a single class. - The requirements of the program should be analyzed so each student is given about the same work load. - The parameters and return types of each function and class member function should be decided in advance. - The program will be best implemented as a multi-file program. Design a generic class to hold the following information about a bank account: Balance Number of deposits this month Number of withdrawals Annual interest rate Monthly service charges The class should have the following member functions: Constructor: Accepts arguments for the balance and annual interest rate. deposit: A virtual function that accepts an argument for the amount of the deposit. The function should add the argument to the account balance. It should also increment the variable holding the number of deposits. withdraw: A virtual function that accepts an argument for the amount of the withdrawal. The function should subtract the argument from the balance. It should also increment the variable holding the number of withdrawals. calcInt: A virtual function that updates the balance by calculating the monthly interest earned by the account, and adding this interest to the balance. This is performed by the following formulas: Monthly Interest Rate = (Annual Interest Rate / 12) Monthly Interest = Balance * Monthly Interest Rate Balance = Balance + Monthly Interest monthlyProc: A virtual function that subtracts the monthly service charges from the balance, calls the calcInt function, and then sets the variables that hold the number of withdrawals, number of deposits, and monthly service charges to zero. Next, design a savings account class, derived from the generic account class. The savings account class should have the following additional member: status (to represent an active or inactive account) If the balance of a savings account falls below $25, it becomes inactive. (The status member could be a flag variable.) No more withdrawals may be made until the balance is raised above$25, at which time the account becomes active again. The savings account class should have the following member functions: withdraw: A function that checks to see if the account is inactive before a with drawal is made. (No withdrawal will be allowed if the account is not active.) A withdrawal is then made by calling the base class version of the function. deposit: A function that checks to see if the account is inactive before a deposit is made. If the account is inactive and the deposit brings the balance above $25, the account becomes active again. The deposit is then made by calling the base class version of the function monthlyProc: Before the base class function is called, this function checks the number of withdrawals. If the number of withdrawals for the month is added to the base class variable that holds the monthly service charges. (Don’t forget to check the account balance after the service charge is taken. If the balance falls below$25, the account becomes inactive.) Next, design a checking account class, also derived from the generic account class. It should have the following member functions: withdraw: Before the base class function is called, this function will determine if a withdrawal (a check written) will cause the balance to go below $0. If the balance goes below$0, a service charge of $15 will be taken from the account. (The withdrawal will not be made.) If there isn’t enough in the account to pay the service charge, the balance will become negative and the customer will owe the negative amount to the bank. monthlyProc: Before the base class function is called, this function adds the monthly the base class function is called, this function adds the monthly variable that holds the monthly service charges. Write a complete program that demonstrates these classes by asking the user to enter the amounts of deposits and withdrawals for a savings account and checking account. The program should display statistics for the month, including beginning balance, total amount of deposits, total amount of withdrawals, service charges, and ending balance. NOTE: You may need to add more member variables and functions to the classes than those listed above. Verified answer Recommended textbook solutions
Other Quizlet setsWhat are the databases used for?Database software makes data management simpler by enabling users to store data in a structured form and then access it. It typically has a graphical interface to help create and manage the data and, in some cases, users can construct their own databases by using database software.
What is a database and its uses quizlet?database. a collection of related information organized for rapid search and retrieval. database management system. software that allows the computer to create a database; add, change, and delete data in the database; sort the data; retrieve the data; and create forms and reports using the data in the database.
What is a database in answer?A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).
What is a database record quizlet?Record. a collection of fields that appear as a row in a database or table. Report. a document that uses data from tables and/or queries, the user controls which items in the database will appear in the report and how it is filtered or sorted. Sort.
|
