Sondt File Student Number Student Name Address Telephone (v) Corse File Course Number Description Hours Professor Number Professor File Professor Number Name Office Registration File Student Number Course Number Date Consider a suitable sample of tuples / records for the above mentioned table write DML statements (SQL) to answer for the queries listed below. Which courses does a specific professor teach ? i What courses are taught by two specific professors ? iWho teaches a specific course and where is his/her office ? to) For a specific student number, in which courses is the student registered and w is Iis/her name ?

Sondt File Student Number Student Name Address Telephone (v) Corse File Course Number Description Hours Professor Number Professor File Professor Number Name Office Registration File Student Number Course Number Date Consider a suitable sample of tuples / records for the above mentioned table write DML statements (SQL) to answer for the queries listed below. Which courses does a specific professor teach ? i What courses are taught by two specific professors ? iWho teaches a specific course and where is his/her office ? to) For a specific student number, in which courses is the student registered and w is Iis/her name ?

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 1GZ

See similar textbooks

Similar questions

6.23 LAB: Python insert/update sqlite3 datafiles Given is a Python program that connects to a sqlite database and has one table called writers with two columnns: name - the name of a writer num - the number of works the writer has written The writers table originally has the following data: name, num Jane Austen,6 Charles Dickens,20 Ernest Hemingway,9 Jack Kerouac,22 F. Scott Fitzgerald,8 Mary Shelley,7 Charlotte Bronte,5 Mark Twain,11 Agatha Christie,73 Ian Flemming,14 J.K. Rowling,14 Stephen King,54 Oscar Wilde,1 Update the Python program to ask the user if they want to update entries or add new entries. If the name entered already exists in the writers table then the database record is updated, overwriting the original contents. If the name does not exist in the writers table, then add a new record with the writer's name and number of works. The following TODO sections must be completed. Check if a writer exists in the writers table If the writer exists in the table, locate an…
Given the 5 records below stored in a file, write a code snippet that will extract two elements (fields) from a single record into two separate variables. Use string functions to identify the delimeter and extract the sub strings. Show the declaration of variables. Mohammed Farook;56 Asiphe Ndokani;75 David Johns;62 Craig Smith;81 Katlhego Ntshidi;45
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]+","…
Retrieve quartsal.cpp from the Lab 7 folder. The code is as follows:// This program will read in the quarterly sales transactions for a given number// of years. It will print the year and transactions in a table format.// It will calculate year and quarter total transactions.// PLACE YOUR NAME HERE#include <iostream>#include <iomanip>using namespace std;const MAXYEAR = 10;const MAXCOL = 5;typedef int SalesType[MAXYEAR][MAXCOL]; // creates a new 2D integer data typevoid getSales(SalesType, int&); // places sales figures into the arrayvoid printSales(SalesType, int); // prints data as a tablevoid printTableHeading(); // prints table headingint main(){int yearsUsed; // holds the number of years usedSalesType sales; // 2D array holding// the sales transactionsgetSales(sales, yearsUsed); // calls getSales to put data in arrayLesson 7B 133printTableHeading(); // calls procedure to print the headingprintSales(sales, yearsUsed); // calls printSales to display tablereturn…
Assume that a file contains students’ ids, full names, and their scores (Assignments grade, quizzes grade,Midterm grade, Practical exam grade, and final exam grade) (each column is separated by $). You arerequired to write a C program to do the following: Using the concept of parallel arrays create records for students with above attributes (id, full name,score).(you are not allowed to use structure) Ask the user to enter the input file name and read it (suppose that, there are different files youcould read data from). Read the data from the file and store it in record for students, which hasIDs, Names, and Scores. The IDs should be declared as integers, the Names as a two-dimensionalarray of characters and the Scores as doubles. Assume that the maximum length of full name ofany student is 50 characters. Also, you may assume that there will be No more than a 1000 studentrecords in the file. Calculate the final grade as the flowing:Grade= (Assignment)*15%+(Quizzes) *15%+(Midterm…
Assume that a file contains students’ ids, full names, and their scores (Assignments grade, quizzes grade,Midterm grade, Practical exam grade, and final exam grade) (each column is separated by $). You arerequired to write a C program to do the following: Using the concept of parallel arrays create records for students with above attributes (id, full name,score).(you are not allowed to use structure) Ask the user to enter the input file name and read it (suppose that, there are different files youcould read data from). Read the data from the file and store it in record for students, which hasIDs, Names, and Scores. The IDs should be declared as integers, the Names as a two-dimensionalarray of characters and the Scores as doubles. Assume that the maximum length of full name ofany student is 50 characters. Also, you may assume that there will be No more than a 1000 studentrecords in the file. Calculate the final grade as the flowing:Grade= (Assignment)*15%+(Quizzes) *15%+(Midterm…
Assume that a file contains students’ ids, full names, and their scores (Assignments grade, quizzes grade,Midterm grade, Practical exam grade, and final exam grade) (each column is separated by $). You arerequired to write a C program to do the following: Using the concept of parallel arrays create records for students with above attributes (id, full name,score).(you are not allowed to use structure) Ask the user to enter the input file name and read it (suppose that, there are different files youcould read data from). Read the data from the file and store it in record for students, which hasIDs, Names, and Scores. The IDs should be declared as integers, the Names as a two-dimensionalarray of characters and the Scores as doubles. Assume that the maximum length of full name ofany student is 50 characters. Also, you may assume that there will be No more than a 1000 studentrecords in the file. Calculate the final grade as the flowing:Grade= (Assignment)*15%+(Quizzes) *15%+(Midterm…
Create a data file in Python using open, write and close functions. Your data file should contain your personal information: Complete name, student number, date of birth, and complete address help me here complete name: cloe jake gonzales student number: 12-1485 date of birth: january 12 1982 complete add: anastasia,1485 sokor, UAE
6.22 LAB: Python and sqlite basics Write a Python program that connects to a sqlite database. Create a table called Horses with the following fields: id (integer): a primary key and not null name (text) breed (text) height (real) birthday (text) Next, insert the following data row into the Horses table: id: 1 name: 'Babe' breed: 'Quarter Horse' height: 15.3 birthday: '2015-02-10' Output all records from the Horses table. Ex: With the above row inserted, the output should be: All Horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') LAB
Soundex() function is used to search for records based on the sound ofA) entire cell valueB) individual words in a cellC) entire recordD) column name
5.8 LAB - Database programming with Python (SQLite) Complete the Python program to create a Horse table, insert one row, and display the row. The main program calls four functions: create_connection() creates a connection to the database. create_table() creates the Horse table. insert_horse() inserts one row into Horse. select_all_horses() outputs all Horse rows. Complete all four functions. Function parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text 'Babe' Breed text 'Quarter horse' Height double 15.3 BirthDate text '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') This lab uses the SQLite database rather than MySQL. The Python API for SQLite is similar to MySQL Connector/Python. Consequently,…
5.8 LAB - Database programming with Python (SQLite) Complete the Python program to create a Horse table, insert one row, and display the row. The main program calls four functions: create_connection() creates a connection to the database. create_table() creates the Horse table. insert_horse() inserts one row into Horse. select_all_horses() outputs all Horse rows. Complete all four functions. Function parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text 'Babe' Breed text 'Quarter horse' Height double 15.3 BirthDate text '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') This lab uses the SQLite database rather than MySQL. The Python API for SQLite is similar to MySQL Connector/Python. Consequently, the…