Books(ISBN, Name, Price, NumberOfCopies) -Identify a primary key generate and execute a python SQL DDL command to
Fantastic news! We've Found the answer you've been seeking!
Question:
Books(ISBN, Name, Price, NumberOfCopies)
-Identify a primary key generate and execute a python SQL DDL command to Create table.
-Make your own data and insert 10 rows in the table created using python SQLite.
-Retrieve all the records from the table Books.
-Insert another record in the table as ('9875465248','Programming With Python',100,50)
-Update the record inserted above – Price -> new Value -> 60 and Number of copies -> new value -> 100
-Delete the record from the above table where number of copies = 100
-Retrieve all the records again from the Books table.
-Retrieve sum of all copies and the avg price from the above table.
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date: