IN java YOUR TASK IS TO IMPLEMENT A JAVA APPLICATION WHICH WILL FUNCTION AS ATYPE OF STUDENT REGISTRATION DATABASE WHICH WILL ENABLE AN ADMINISTRATIVE USER TO EITHER CREATE OR DELETE ASTUDENT ACCOUNT IN THE DATABASE IN ORDER TO STORE THE FOLLOWING DETAILS:-(1)THE STUDENT’S NAME,(4) THE STUDENT’S ID NUMBER,(3) A LIST OF THE COURSES WHICH THE STUDENT HAS TAKEN ALONG WITH THE CORRESPONDING GRADES FOR THESECOURSES.NOTE: WHEN THE VALUE -1 IS ENTERED, THE APPLICATION WILL TERMINATE.please check the attached image YOUR TASK IS TO IMPLEMENT A JAVA APPLICATION WHICH WILL FUNCTION AS ATYPE OF STUDENT REGISTRATION DATABASE WHICH WILL ENABLE AN ADMINISTRATIVE USER TO EITHER CREATE OR DELETE ASTUDENT ACCOUNT IN THE DATABASE IN ORDER TO STORE THE FOLLOWING DETAILS:-(1)THE STUDENT'S NAME,(11) THE STUDENT'S ID NUMBER,(111) A LIST OF THE COURSES WHICH THE STUDENT HAS TAKEN ALONG WITH THE CORRESPONDING GRADES FOR THESECOURSES.NOTE: WHEN THE VALUE -1 IS ENTERED, THE APPLICATION WILL TERMINATE.A TYPICAL EXAMPLE OF THE PROGRAM'S INPUT AND OUTPUT IS SHOWN BELOW:Enter "1" to print out the full name & ID of every student in the database,"2" to enter the course codes and grades for a specific student's ID,"3" to retrieve the courses and grades for a specific student's ID or,"4" to register a new student to the database or"-1" to quit the program: 1The full name of student #1 is: Mariam Baksh, ID: 201910077The full name of student #2 is: Noora AlBeloushi, ID: 201810010The full name of student #3 is: Ali AlEkabi, ID: 201910075Enter "1" to print out the full name & ID of every student in the database,"2" to enter the course codes and grades for a specific student's ID,"3" to retrieve the courses and grades for a specific student's ID or,"4" to register a new student to the database or"-1" to quit the program:Enter new student's UoF ID: 201912345Enter new student's first name: AhmadEnter new student's last name: HantoobiEnter new student's age: 26Registration Successful, the new student is Ahmad Hantoobi, UoF ID: 201912345Enter "1" to print out the full name & ID of every student in the database,"2" to enter the course codes and grades for a specific student's ID,"3" to retrieve the courses and grades for a specific student's ID or,"4" to register a new student to the database or"-1" to quit the program: -1Application wil1 now exit, goodbye!NOTE: THE JAVA APPLICATION WHICH YOU WILL DEVELOP SHOULD INCORPORATE THE FOLLOWING FUNCTIONALITY:SOME OPERATION TO RETRIEVE THE STUDENT'S NAME IF THE USER PROVIDES AN ID NUMBER (AND SUCH AN IDNUMBER CANNOT EVER HAVE BEEN ASSIGNED TO ANOTHER STUDENT OR BE RE-ASSIGNED TO A FUTURE STUDENT)SOME OPERATION TO DELETE A STUDENT RECORD ALONG WITH HIS/HER ID AND ASSOCIATED COURSES ANDGRADES, THIS WOULD THEN CAUSE A RE-ORDERING OF ARRAY SLOTS TO MAKE SURE THAT NO EMPTY SLOTS ARELEFT AFTER A RECORD HAS BEEN DELETED.SOME OPERATION TO ENABLE THE REPLACEMENT OF AN EXISTING GRADE ONLY WITH A BETTER GRADE FOR AGIVEN STUDENT . AND NOTE THAT THE SAME COURSE CODE CANNOT BE LISTED TWICE FOR THE SAME STUDENT.

It is defined as programs can be asked from control statements, array, string, oops etc. Java basic…

YOUR TASK IS TO IMPLEMENT A JAVA APPLICATION WHICH WILL FUNCTION AS A TYPE OF STUDENT REGISTRATION DATABASE WHICH WILL ENABLE AN ADMINISTRATIVE USER TO EITHER CREATE OR DELETE A STUDENT ACCOUNT IN THE DATABASE IN ORDER TO STORE THE FOLLOWING DETAILS:- (1)THE STUDENT’S NAME, (4) THE STUDENT’S ID NUMBER, (3) A LIST OF THE COURSES WHICH THE STUDENT HAS TAKEN ALONG WITH THE CORRESPONDING GRADES FOR THESE COURSES. NOTE: WHEN THE VALUE -1 IS ENTERED, THE APPLICATION WILL TERMINATE. please check the attached image

YOUR TASK IS TO IMPLEMENT A JAVA APPLICATION WHICH WILL FUNCTION AS A TYPE OF STUDENT REGISTRATION DATABASE WHICH WILL ENABLE AN ADMINISTRATIVE USER TO EITHER CREATE OR DELETE A STUDENT ACCOUNT IN THE DATABASE IN ORDER TO STORE THE FOLLOWING DETAILS:- (1)THE STUDENT’S NAME, (4) THE STUDENT’S ID NUMBER, (3) A LIST OF THE COURSES WHICH THE STUDENT HAS TAKEN ALONG WITH THE CORRESPONDING GRADES FOR THESE COURSES. NOTE: WHEN THE VALUE -1 IS ENTERED, THE APPLICATION WILL TERMINATE. please check the attached image

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

Hello, I am having an error and cannot figure out how to solve this question. Could someone please assist? Please be advised, I am using PostgreSQL as that is what was used in class. Thus, I must use PLPGSQL Code CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction()RETURNS TRIGGERLANGUAGE PLPGSQLAS$$CREATE TRIGGER Wise_12_bankTriggerAFTER DELETE ON accountFOR EACH ROW EXECUTE PROCEDURE Moreno_15_bankTriggerFunction();
Hello, I am having an error and cannot figure out how to solve this question. Could someone please assist? Please be advised, I am using PostgreSQL as that is what was used in class. Thus, I must use PLPGSQL Application: PostgreSQL 12 or 13PLPGSQL CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction()RETURNS TRIGGERLANGUAGE PLPGSQLAS$BODY$CREATE TRIGGER Moreno_03_bankTriggerAFTER DELETE ON accountFOR EACH ROW EXECUTE PROCEDURE Moreno_15_bankTriggerFunction(); TABLES (if needed) CREATE TABLE branch (branch_name varchar(35),branch_city varchar(15),assets numeric(15,2) CHECK (assets > 0.00),CONSTRAINT branch_pkey PRIMARY KEY (branch_name));CREATE TABLE customer (ID varchar(15),customer_name varchar(25) NOT NULL,customer_street varchar(35),customer_city varchar(15),CONSTRAINT customer_pkey PRIMARY KEY (ID));CREATE TABLE loan (loan_number varchar(15),branch_name varchar(35),amount numeric(15,2),CONSTRAINT loan_pkey PRIMARY KEY (loan_number),CONSTRAINT loan_fkey FOREIGN KEY…
Write a program that connects to a database, creates a Moviestable (if it does not already exist), and provides the user the ability to manage a movie listing database. The database shouldinclude fields for a movie’s name, run-time, rating code, date ofrelease, and two primary stars. The user should be able to enternew movie information, delete existing movies, and obtain a listof movies in the database.
using c++ In this assignment you are going to implement your own version of university library system,Thesystem will have two different sides , the first one is to help the librarian to do his job and the other side for admin to manage every one permissions in the system , so You should provide the following features in your system: Admin view o Add/remove Studentso Add/remove librarian o Add/remove other admins Librarian viewo Add/Delete bookso Issue/Return bookso View bookso View Issued bookso Log in /log outo Search for the book(id/name) Simple backend for your system , You could use a file each row should represent itemo Books File should be something like:Id , Book Name, Author Name, Available quantity, Issued Quantity1,Oliver Twist, Charles Dickens,98,2In the previous the first row was the name of each column , you can do that or handle it in your code , id =1 , Book Name =Oliver Twist ..Etc. Tables neededo Books Id  Book Name Author Name Available quantity Issued…
Write a program in c Build an application for a car rental company. It should offer the following features: • Maintain a customer database in a file:o Register / add new customers. Customer information should include ▪ Customer ID number▪ Name▪ Phone numbero Searchcustomerdatabaseby:▪ Customer ID number▪ Name▪ Phone numberAnd print out the matching records• Maintain a database in a file:o Add a new vehicle to the fleet. Vehicle information should include▪ Model year▪ Make▪ Model name▪ License plate number▪ Customer number who is currently renting vehicleo Deleteavehiclefromthefleeto Rent a vehicle to a registered customero Receiverentedvehiclebackfromcustomer o Search vehicle database by any field:▪ Model year + Make + Model name▪ License plate number▪ Customer number who is currently renting vehicle And print out all matching records
Implement the DBS Share Price Index System in Python as per Figure 2 below which allows users toadd, delete, update and lookup Share Prices. The System should store the Company Name and SharePrice. Your program should not allow users to add the same company more than once. On adding,deleting, updating or looking up a Share Price, your program should let the user know if theoperation was successful or not. On looking up a Share Price return the Company Name and SharePrice of the company; if the company is not found give the user the option to add the details theyare looking up. The user can perform multiple actions; they can add a new entry and subsequentlydelete an entry without having to stop and start the program until they decide to quit
Write a Java GUI application that will keep track of student results at a local college and save the process result into a database. The application must contain the result that a student has obtain for a test, assignment and exam
Using the python code below. Identify the Variabale, Conditional Statement,Operators,Loops and Functions used in the code below. PYTHON CODE: file1 = open('database.txt', 'r') count = 0 name = [] age = [] dep = [] address = [] sr_code = [] status = [] condition = [] while True: count += 1 line = file1.readline() # if line is empty # end of file is reached if not line: break else: try: data = line.split(",") name.append(data[0]) age.append(data[1]) dep.append(data[2]) address.append(data[3]) sr_code.append(data[4]) status.append(data[5]) condition.append(data[6]) except: none = "" file1.close() def dataUp(): with open("database.txt", "w") as f: for i in range(0,len(name)): f.write(name[i]+","…
EXPLAIN THE BELOW PYTHON AND DBMS CODE STEP BY STEP WITH TERMINOLOGY import osimport platformimport mysql.connectorimport pandas as pdimport datetimemydb = mysql.connector.connect(user='root', password='Arun@102003',host='localhost',database='food')mycursor=mydb.cursor() def MenuSet(): #Function Food Booking System print("Enter 1 : To Add Cutomer details") print("Enter 2 : For Food Order") print("Enter 3 : Exit") try: #Using Exceptions For Validation userInput = int(input("Please Select An Above Option: ")) #Will Take Input From User except ValueError: exit("\nHy! That's Not A Number") #Error Message else: print("\n") #Print New Line if(userInput == 1): Customer() elif (userInput==2): orderitem() elif (userInput==3): Food() elif (userInput==4): OrderFood() elif (userInput==5): View() else: print("Enter correct choice. . . ") MenuSet() def Customer(): L=[] c_name=input("Enter…
Create a database with several built-in functions.
Write a Python sqlite3 based program that stores names and dates of birth in a database. The established database includes at least 5 rows. Extend the program so that it stores the format of the data in the database: in other words, create a system catalog. Write test programs to prove that this system catalog is accessible to external users.
Write a C++ program using Windows API to CreateDirectory – For Creating the Directory BOOL CreateDirectory(LPCSTR lpPathName, LPSECURITY_ATTRIBUTES lpSecurityAttributes ); Return Type – Boolean (TRUE or FALSE). LPCSTR – Long Pointer to constant String. lpPathName – Where your directory will reside. lpSecurityAttributes – Security for Directory and default it is NULL. If this function Fails then its return FALSE or ZERO. Also We can print the Error Information with the help of GetLastError() function. CreateDirectory Function Link.