Related questions
Case Programming Assignments
4
ONLINE DEGREES
Design a Windows application and write the code that will execute according to the program requirements in Figure 10-71. Before designing the user interface, create a Use Case Definition. Before writing the code, create an event planning document for each event in the program.
ReQuiRemeNTS DOCumeNT Date:
March 9, 2019
Date Submitted:
Application Title:
Purpose: Online Degrees
This Windows application opens an Access
Program Procedures:
Algorithms, Processing, and
Conditions:
In a Windows application, the Access database file is opened and the user can view, add, and delete records as needed. The total student population and number of students in a particular major can also be displayed.
1. The user first views a Windows application that loads an Access database table, which includes fields for the department, college major, and number of students in that major. A navigation toolbar appears at the top of the Windows form, allowing the user to move from record to record. The Windows form also includes a title.
2. The user can click the Add new button on the navigation toolbar to add a new major to the online college. The record is saved when the user clicks the Save Data button on the navigation toolbar.
3. The user can click the Delete button on the navigation toolbar to delete a major. The record is permanently deleted when the user clicks the Save Data button on the navigation toolbar.
4. The user can click the Find Total Button object to compute the total number of students enrolled in each major.
5. The user can select a major from a ComboBox list and the application will display the number of students at the college participating in that major.
Notes and Restrictions:
Comments: The College.accdb file is located on the USB drive (the D drive).
1. The College.accdb file is available on CengageBrain.com. 2. Use a graphic image you obtain from the web.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 5 images
- Data redundancy is when the same data is stored in numerous places in a database. This redundancy may cause data to become __________, which occurs when multiple copies of the same data no longer share the same value. What is the underline word?arrow_forwardUsing C# in Visual Studio: Create the graphical user interfaces as shown below. Provide appropriate names for all the controls.arrow_forwardScenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…arrow_forward
- linux makefile topic Running “make” command without the arguments starts the target ____ in the makefile.arrow_forwardimport sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection(): """ Create a connection to in-memory database :return: Connection object """ try: conn = sqlite3.connect(":memory:") return conn except Error as e: print(e) # YOUR CODE HERE # Use sqlite3.connect(":memory:") to create connection object return conn # query to create the table table_sql = """ CREATE TABLE Horses ( id integer PRIMARY KEY NOT NULL, name text, breed text, height real, birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…arrow_forwardWill be using code Lginter! Registration First Name Last Name Email Address Password Confirm Password Require to have validation of user input Valid email address Make sure the email address does not exist in the database before doing insert into the database Password and Confirm Password are matching Password need to hash before doing insert into database ("password_hash" is a PHP build in function which can be used)arrow_forward
- please helparrow_forwardScenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education