{"id":14635,"date":"2023-04-16T12:17:20","date_gmt":"2023-04-16T12:17:20","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/in-this-project-we-will-design-and-implement-a-database-for-an-online-university-bookshop\/"},"modified":"2023-04-16T12:17:20","modified_gmt":"2023-04-16T12:17:20","slug":"in-this-project-we-will-design-and-implement-a-database-for-an-online-university-bookshop","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/in-this-project-we-will-design-and-implement-a-database-for-an-online-university-bookshop\/","title":{"rendered":"In this project, we will design and implement a database for an online university bookshop."},"content":{"rendered":"<p>Each book has a book id, a title, an author, a price, and an amount (amount of<\/p>\n<div>books in stock).\n<\/div>\n<div>\u2022 For every student, we must capture her\/hisstudent id, name, gender, major, and\n<\/div>\n<div>discount level.\n<\/div>\n<div>\u2022 When an order is successfully placed by a student, an order record should be\n<\/div>\n<div>added to the database. Each order contains at least the following information: a\n<\/div>\n<div>student, an order date, books ordered, a total price, a payment method, a card\n<\/div>\n<div>no. (if the payment method is by credit card). Once the order is cancelled by the\n<\/div>\n<div>student, the corresponding order record will be removed.\n<\/div>\n<div>\u2022 The books in an order may be delivered on different dates. For each book of an\n<\/div>\n<div>order, record its delivery date. After some book has been delivered to the\n<\/div>\n<div>student, the order can no longer be cancelled.\n<\/div>\n<div>\u2022 A student can enjoy 10% (20%) discount if her\/his total order in the current\n<\/div>\n<div>year has exceeded $1,000 ($2,000). Each book has a book id, a title, an author, a price, and an amount (amount of\n<\/div>\n<div>books in stock).\n<\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Each book has a book id, a title, an author, a price, and an amount (amount of books in stock). \u2022 For every student, we must capture her\/hisstudent id, name, gender, major, and discount level. \u2022 When an order is successfully placed by a student, an order record should be added to the database. Each [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[211],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/14635"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=14635"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/14635\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=14635"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=14635"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=14635"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=14635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}