PRP201c_-_FA_2022_-_PE_133.webp
Aizawa2004

PRP201c_-_FA_2022_-_PE_133.webp

3. (4 points) Write a program to manage Product list of a shop using database file PRODUCT.sqlite. The program reads data from the file "Category.txt", and "Product.txt" and then save to the tables CATEGORY and PRODUCT respectively.
CATEGORY (CatID, CatName)
PRODUCT (PID, PName, CatID)
The program prints the Product list which belong to "Tivi" or "Phone" category and sorted in Descending order by PName. The output should be as follows:
PRODUCT LIST:
ID
Product Name
Category
Tivi
Tivi
TV02
Samsung 50
TV01
Samsung 43
PH03
SamSung S13
Phone
PH01
PH02
IPhone 14
Phone
IPhone 13
Phone
Zoom
+ 100%
Close
Chưa có bình luận nào.

Thông tin

Category
PRP201c
Thêm bởi
Aizawa2004
Ngày thêm
Lượt xem
737
Lượt bình luận
0
Rating
0.00 star(s) 0 đánh giá

Share this media

Back
Bên trên Bottom