Question

Create a database with the name your_firstname_last_4_digits_of_student_id (example Sachin_0932). In the database create a table using python code with CREATE TABLE command with the name of yourfirstname_relatives (Example: Sachin_relatives) with the following attributes or fields, field name will start with the first character of first name: Field Name Data Type Description SR_ID INT (PK) Relative ID SR_Lname Text Relative Last Name SR_Fname Text Relative First Name SR_Age INT Relative Age SR_Relation Text Relation with you Using Python code, a) Insert 5 records using the INSERT INTO command b) Use the SELECT command to view all relative information c) Update age of one relative record using the UPDATE command d) Delete one record using the Delete command (based on your data) In the same database create a table using python code with CREATE TABLE command with the name of yourfirstname_guests (Example: Sachin_guests) with the following attributes or fields, field name will start with the first character of first name: Field Name Data Type Description SG_ID INT (PK) Guest ID SG_Phone INT Guest Phone Number SGR_ID INT Relative ID Using Python code, a) Insert two records from relatives file (SR_ID = SGR_ID) b) Join and view the guest ID, Guest first name and phone number 

          Create a database with the name your_firstname_last_4_digits_of_student_id (example Sachin_0932). In the database create a table using python code with CREATE TABLE command with the name of yourfirstname_relatives (Example: Sachin_relatives) with the following attributes or fields, field name will start with the first character of first name:
Field Name	Data Type	Description
SR_ID	INT (PK)	Relative ID
SR_Lname	Text	Relative Last Name
SR_Fname	Text	Relative First Name
SR_Age	INT	Relative Age
SR_Relation	Text	Relation with you
Using Python code,
a) Insert 5 records using the INSERT INTO command
b) Use the SELECT command to view all relative information
c) Update age of one relative record using the UPDATE command
d) Delete one record using the Delete command (based on your data)
In the same database create a table using python code with CREATE TABLE command with the name of yourfirstname_guests (Example: Sachin_guests) with the following attributes or fields, field name will start with the first character of first name:
Field Name	Data Type	Description
SG_ID	INT (PK)	Guest ID
SG_Phone	INT	Guest Phone Number
SGR_ID	INT	Relative ID
Using Python code,
a) Insert two records from relatives file (SR_ID = SGR_ID)
b) Join and view the guest ID, Guest first name and phone number
Show more…
Create a database with the name yourfirstnamelast4digitsofstudentid (example Sachin0932). In the database create a table using python code with CREATE TABLE command with the name of yourfirstnamerelatives (Example: Sachinrelatives) with the following attributes or fields, field name will start with the first character of first name: Field Name Data Type Description SRID INT (PK) Relative ID SRLname Text Relative Last Name SRFname Text Relative First Name SRAge INT Relative Age SRRelation Text Relation with you Using Python code, a) Insert 5 records using the INSERT INTO command b) Use the SELECT command to view all relative information c) Update age of one relative record using the UPDATE command d) Delete one record using the Delete command (based on your data) In the same database create a table using python code with CREATE TABLE command with the name of yourfirstnameguests (Example: Sachinguests) with the following attributes or fields, field name will start with the first character of first name: Field Name Data Type Description SGID INT (PK) Guest ID SGPhone INT Guest Phone Number SGRID INT Relative ID Using Python code, a) Insert two records from relatives file (SRID = SGRID) b) Join and view the guest ID, Guest first name and phone number

Added by Lisa D.

Close

Computer Science and Information Technology
Computer Science and Information Technology
Trishna Knowledge Systems 2018 Edition
AceChat toggle button
Close icon
Ace pointing down

Please give Ace some feedback

Your feedback will help us improve your experience

Thumb up icon Thumb down icon
Thanks for your feedback!
Profile picture
Create a database with the name your firstname last 4 digits of student id (example Sachin 0932). In the database create a table using python code with CREATE TABLE command with the name of yourfirstname relatives (Example: Sachin relatives) with the following attributes or fields,field name will start with the first character of first name: Field Name SR_ID SR_Lname SR Fname SR_Age SR Relation Data Type INT(PK) Texr Txt INT Text Description Relative ID Relative Last Name Relative First Name Relative Age Relation with you Using Python code, a)Insert5 records using the INSERT INTO command b) Use the SELECT command to view all relative information c) Update age of one relative record using the UPDATE command d) Delete one record using the Delete command (based on your data) In the same database create a table using python code with CREATE TABLE command with the name of yourfirstname guests (Example:Sachin_guests) with the following attributes or fields,field name will start with the first character of first name: Field Name SG_ID SG_Phone SGRID Data Type INT(PK) INT INT Description Guest ID Guest Phone Number Relative ID Using Python code a)Insert two records from relatives fileSR ID=SGR ID b) Join and view the guest ID,Guest first name and phone number
Close icon
Play audio
Feedback
Powered by NumerAI
David Collins Ivan Kochetkov
Jennifer Stoner verified

Supreeta N and 78 other subject AP CS educators are ready to help you.

Ask a new question
*

Labs

-

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs
*

Key Concepts

-
Key Concept
Premium Feature
Explore the core concept behind this problem.
Play button
Key Concept
Premium Feature
Explore the core concept behind this problem.
Your browser does not support the video tag.
*

Recommended Videos

-
create-a-python-program-that-allows-user-enter-class-name-faculty-name-name-of-each-student-and-number-score-each-student-earned-the-program-should-then-call-a-function-to-covert-the-number-46102

Create a Python program that allows the user to enter the class name, faculty name, name of each student, and the number score each student earned. The program should then call a function to convert the number score into a letter grade. The program should count and display the number of students who earned As, Bs, Cs, Ds, and Fs at the end of the program. Additionally, the program should save all input and output information into a text file. The file should be named with the user-entered class name, faculty name, followed by "Grades.txt". For example, if the user entered class name is "CTI120" and the faculty name is "Smith", the file name should be "CTI120SmithGrades.txt".

Supreeta N.
in-python-1-write-a-program-named-filemakerpy-that-will-be-used-to-store-the-first-name-and-age-of-some-friends-in-a-text-file-named-friendstxt-the-program-must-use-a-while-loop-that-prompts-14901

Write a program named filemaker.py that will be used to store the first name and age of some friends in a text file named friends.txt. The program must use a while loop that prompts the user to enter the first name and age of each friend. Each of these entries should be written to its own line in the text file (2 lines of data per friend). The while loop should repeat until the user presses Enter (Return on a Mac) for the name. Then, the file should be closed and a message should be displayed. See Sample Output. SAMPLE OUTPUT Enter first name of friend or Enter to quit: Denny Enter age (integer) of this friend: 24 Enter first name of friend or Enter to quit: Penny Enter age (integer) of this friend: 28 Enter first name of friend or Enter to quit: Lenny Enter age (integer) of this friend: 20 Enter first name of friend or Enter to quit: Jenny Enter age (integer) of this friend: 24 Enter first name of friend or Enter to quit: File was created

Aarya B.
write-a-python-app-that-will-accept-student-names-and-gpas-and-test-if-the-student-qualifies-for-either-the-deans-list-or-the-honor-roll-your-app-will-ask-for-and-accept-a-students-last-name-28127

Write a Python app that will accept student names and GPAs and test if the student qualifies for either the Dean's List or the Honor Roll. Your app will: - Ask for and accept a student's last name. - Quit processing student records if the last name entered is 'ZZZ'. - Ask for and accept a student's first name. - Ask for and accept the student's GPA as a float. - Test if the student's GPA is 3.5 or greater and, if so, print a message saying that the student has made the Dean's List. - Test if the student's GPA is 3.25 or greater and, if so, print a message saying that the student has made the Honor Roll. - Test your app using at least five students. Your header comments need to contain: - A brief description of what your app will do

Supreeta N.
*

Recommended Textbooks

-
Computer Science and Information Technology

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition
achievement 1,783 solutions
Introduction to Programming Using Python

Introduction to Programming Using Python

Y. Daniel Liang 1st Edition
achievement 1,838 solutions
Computer Science - An Overview

Computer Science - An Overview

Glenn Brookshear, Dennis Brylow 12th Edition
achievement 1,437 solutions
*

Transcript

-
00:01 Hello students, here is the python program that implements all the requirements you have assigned.
00:07 So, when you run this program, it will ask you to enter the class name as well as the faculty name and the number of students and then ask for the name and the score of the each student.
00:21 It will convert the scores into the letters, letter grades and using the get letter using the get letter as the get letter grade.
00:35 So, function and save all the input and output information into the text file named according to your specification.
00:42 So, the grade distribution will be displayed at the end of your program like as you can see, it will ask to enter the class name like you can just with an example, i will just provide you with an example.
01:01 So, the class name, class name, enter the class name as c t 1 c t i 1 2 0, then later with a faculty name, faculty name as the smith and next let's consider the number of students, number of students be 3 and the student 1, student 1 name, name as the name of the student 1 as the alice and alice scores and alice score, score.
01:41 So, let us consider the alice score be an score be an 85...
Need help? Use Ace
Ace is your personal tutor. It breaks down any question with clear steps so you can learn.
Start Using Ace
Ace is your personal tutor for learning
Step-by-step explanations
Instant summaries
Summarize YouTube videos
Understand textbook images or PDFs
Study tools like quizzes and flashcards
Listen to your notes as a podcast
Continue solving this problem
Create a free account to:
  • View full step-by-step solution
  • Ask follow-up questions with Ace AI
  • Save progress and study later
Continue Free
Join the community

18,000,000+

Students on Numerade

Trusted by students at 8,000+ universities

Numerade

Get step-by-step video solution
from top educators

Continue with Clever
or



By creating an account, you agree to the Terms of Service and Privacy Policy
Already have an account? Log In

A free answer
just for you

Watch the video solution with this free unlock.

Numerade

Log in to watch this video
...and 100,000,000 more!


EMAIL

PASSWORD

OR
Continue with Clever