Find
Search for over 200,000 study notes and past assignments!
Swap
Download study resources by swapping your own or buying Exchange Credits.
Study
Study from your library anywhere, anytime.
2 Found helpful • 25 Pages • Essays / Projects • Year Uploaded: 2021
Case Study: APU’s E-Bookstore The availability of books and reading material for purchase within the Asia Pacific University (APU) is quite inadequate. Although the APU library has vast collection of books (both hardcopy and e-books), the availability of it is quite limited and bound by many restrictions. Student and staffs only have the option of a small bookshop within the enterprise. Larger books store in the city are often sought for other varieties. In view of the growing population within APU, the university is planning to establish an e-bookstore. The online store will facilitate the purchase of latest books of many genres. Your team is assigned the project to design and implement a database system for online APU’s e-Bookstore System. Component: a) Database Schema • Re-submit the Entity Relationship Diagram, you may make changes to the ERD submitted in Part 1 • Generate the database diagram from the DBMS b) SQL-Data Definition Language (DDL) • Create all tables with suitable data types • Insert 5-10 rows of data into each table • Screen shot all tables with its data • Screen shot all query statements c) SQL-Data Manipulation Language (DML) • Write SQL statements to answer question (2) above • Screen shot all query statements together with its executed result
This document is 10 Exchange Credits
More about this document:
|
|
This document has been hand checkedEvery document on Thinkswap has been carefully hand checked to make sure it's correctly described and categorised. No more browsing through piles of irrelevant study resources. |
|
|
This is an Essay / ProjectEssays / Projects are typically greater than 5 pages in length and are assessments that have been previously submitted by a student for academic grading. |
|
|
What are Exchange Credits?Exchange Credits represent the worth of each document on Thinkswap. In exchange for uploading documents you will receive Exchange Credits. These credits can then be used to download other documents for free. |
|
|
Satisfaction GuaranteeWe want you to be satisfied with your learning, that’s why all documents on Thinkswap are covered by our Satisfaction Guarantee. If a document is not of an acceptable quality or the document was incorrectly described or categorised, we will provide a full refund of Exchange Credits so that you can get another document. For more information please read Thinkswap's Satisfaction Guarantee. |
Studying with Academic Integrity
Studying from past student work is an amazing way to learn and research, however you must always act with academic integrity.
This document is the prior work of another student. Thinkswap has partnered with Turnitin to ensure students cannot copy directly from our resources. Understand how to responsibly use this work by visiting ‘Using Thinkswap resources correctly’.
Browse APU Subjects
