
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question

Transcribed Image Text:In this Assignment, you will build a supermarket product management app that persists data
offline. You will use IndexedDB and Localbase library to read, add, update, and delete products
in the database.
The Product Management App should have the following CRUD features:
1. Create Product: when the user clicks on the create new product button in
figure 1, you should open the add product page in figure 2 that allows the user
to add a new product. Once they click on the save button, you should navigate
them to the product page and show the newly added Product, as shown in figure
Doha - Supermarket
Add Product
Read Products
Prodat
Figure 1: Product Page - Before adding any product
Doha - Supermarket
Produs
A rodut
Create Product
Ne cer
The best ern the wor
Pce
Figure 2: Add Product page
Doha - Supermarket
A Pr
Read Products
wodc
Deserpon
Pce
Acon
The best N erewo
Figure 3:Product Page - After adding Product
2. List Products: as soon as the application loads, you show all the products saved
in the database in a table, as shown in figure 4.

Transcribed Image Text:Doha - Supermarket
4. Delete Product: Delete the selected Product from the database and reload the
Frodugs
ds Product
page.
Read Products
Doha - Supermarket
Procucts
Ad roduct
localha y
Read Products
Creane New YORKT
Caman
O Nane
Acson
Descnpnan
Price
The best Niga nCkern the wornd
Na sse
Edi
ID Name
Deseriotion
Price
Action
Skeeping wel a mpurlant.
Nga erTD
The be Naya sernme wond
Reat
Dnin
Ephone
You roud thta une Eyou love m
ST
P
Sieping wet a impora
Reat
Edt
Dee
7 Caphore
You need this one e mse
Mouse
Very uaetul f you kove your compuer
S11.35
E
Dekte
eat
Dee
Trash Can
It wil halp you maintain cieaniness.
sa as
53.95
Dee
After you complete the Assignment, fill in the TestingDoc-Grading-Sheet.docx and save it inside
the Assignment3 folder. Push your work to the Github repository.
Eyn Gces
I wil make you read teer
Dek
Tnis ka very goos ank mor amwes
atorte
Ed
De
A DLUseT n the NHÀ
Haea
D
Red
Ed
Figure 4: Products page
3. Edit Products: If the user clicks on the edit product button, you should take the
selected product details to allow the user to update the information of the
selected Product, as shown in Figure 5.
Doha - Supermarket
Produs
Ad Produt
Update Product
Name
N scer EDTED
Descron
The best Ni cherin the wond
Pce
seve Change at prouts
Figure 5 Update Product
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Scenario 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_forwardAssignment Create a database in Access. In the database include the following tables: • Student info which has the following fields o First Name o Last Name o StudentID (primary key) • Courses table which includes the following fields: o CourselD (primary key) o Course Name o CRN • Schedule which contains the following fields: o StudentID o CourselD Create the proper relationships between the tables. Fill the tables with at least 5 students and 2 different classes. You can generate the data randomly by using the Mockaroo site Or you can review Extra Material for more links on how to generate random data Create a report to print out the course and the names of the students taking that course (so group by course). Make sure the report is well formatted, looks professional, include a professional header and a footer.arrow_forwardTask 5: The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation. Task: Create a TRIGGER to run on the USERS table before any UPDATE operation. (SQL Database Test): Create a TRIGGER before any UPDATE operations on the USERS tablearrow_forward
- Create a new user account with readWrite permission for your database using MongoDBarrow_forwardThe Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation. Task Create a TRIGGER to run on the USERS table before any UPDATE operation.arrow_forwardQuestion number 6arrow_forward
- import 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_forwardHow can you create a form that shows the columns of only a single row of a database in an application?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
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education