Books’R’Us is a local bookstore that started in 1978 in a small New England town

Question

Books’R’Us is a local bookstore that started in 1978 in a small New England town. Books’R’Us has been able to withstand the challenges of larger bookstore chains, as well as the internet giant Amazon.com, by offering new and used books and other products in a comfortable location that includes a café with free WiFi. Books’R’Us recently purchased another local bookstore called Great Books, USA, from an owner who is retiring. Both businesses use a simple bookkeeping system that includes Microsoft Excel. The owners of Books’R’Us, Tom and Sarah Smith, would like a more efficient way to store inventory data and report on the various business essentials. They are also preparing to offer e-commerce on their website. A consulting firm has recommended capturing information in a database and linking access to the database for each store. Tom and Sarah purchased Microsoft SQL Server to do this. The consulting firm has hired you to complete the database for Books’R’Us. In addition to creating the database, you will provide a report for your supervisor at the consulting firm; this report should describe the rationale for and proposed development of the database. Imagine that you have interviewed the store owners, Tom and Sarah Smith, and these are the questions with which they are most concerned:

Thinking about stakeholders in terms of our project, what issues and concerns do you foresee arising?

What questions should we ask the owners?

How would you anticipate attending to the issues and concerns?

What are the strengths and weaknesses of our database?

Explanation / Answer

Thinking about the stakeholder in terms of the project the following issue and concern that will come into the mind.

·         How the stakeholder will handle the workload on the server that will arise when the more number of the customer wants to purchase the books.

·         Second concern regarding the server that when the server get heated then at that time how he will deal with that.

·         What are the dealing price for the content that he wants to sell.

·         What would be the dealing strategy that he will choose.

Following are the question that we will ask the owner.

·         What kinds of information will it store?

·         How to have to break down this information so it can be stored in my database.

·         How to use the data once it's in there?

·         What would you want to track with your database?

·         What database tables would you need?

·         What fields will be in each database table?

·         what are privilege access given to each store?

following is the solution to anticipation to attending the issue:

·         Users (should be able to both buy and sell books) - User can sell a book. - User can buy a book.

·         Temp Users - This is for guest user’s login through email or mobile phone.

·         Orders - many orders can be made by one user.

·         Order_Details - stores information on each product that has been ordered, the customer who ordered, address to be delivered.

·         Products/Books - books category, author details, publisher, price details, availability to the pincode of customer.

·         Relationship between the entities.

Strengths:

·         databases ensure better data integrity.

·         Another important structural feature of databases is the existence of foreign keys and primary keys. Database software will enforce the rule that a primary key must be unique for every row in a table, and it will enforce the rule that the value of a foreign key must refer to an existing primary key value.

·         Databases tend to be used for large data sets because, for most DBMS, there is no limit on the size of a database.

·         organization of the data can improve accuracy and efficiency.

·         DBMS provide advanced features that are far beyond what is provided by the software that is used to work with data in other formats.

·         Features include the ability to allow multiple people to access and even modify the data at once and advanced security to control who has access to the data and who can modify the data.

Weakness:

·         Database systems offered by Oracle and Microsoft can be very expensive.
the cost of acquiring or hiring the expertise necessary to create, maintain, and interact with data stored in a database.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.