Premium Essay

Database for Bookstore

In:

Submitted By lnstha
Words 323
Pages 2
Ganesh Shrestha
202010
MIS-4653
Individual assignment #1

a. A database for the university bookstore would be of great help in maintaining control over the inventory which is very important for the efficiency and profitability of the bookstore. The new system would also help the bookstore to maintain details about the books, publishers, customers, payments etc. This new database would also help the bookstore to create its customers profile based on their preferences and send information about any new editions to the book they like or any other bookstore deal, directly to the customer. The database for the bookstore can also provide accurate information about the stock in house and a clear picture of the stock levels regarding the books and supplies that is present at a particular point of time. It can be of great help as it will make sure that the bookstore has sufficient stock to meet the demands of the students without overstocking. A database also can help in studying the trend that’s going on which could again help in forecasting the future demand for products and supplies. One can monitor the movement of all different types of products and supplies and can identify the best sellers and the slow movers based on which one can rationalize the different types of product and concentrate more on the products that result in maximum profit.

b. The major topics of this database for the bookstore would be the following: * Customer: The main points would include customer ID, name, address, phone number, e-mail, reading preferences, profession etc. * Customer history: It would include customer ID, ISBN number, date of order, delivery date etc. * Books: Important terms would include ISBN of the book, title, author, price, year of publication etc. * Publisher: This topic covers publisher identification number, name, address, phone number etc. *

Similar Documents

Free Essay

Bis Wk 4 Outline

...Bookstore Research Outline First M Last BIS 320 Business Information Systems August 27, 2014 Professors Name Bookstore Research I. Introduction A. Brief history of how each bookstore was founded, how far they have come to this day. II. Body A. Background bookstore information B. How each bookstore uses their database? 1. Discuss the use of software and hardware C. What type of information is stored in each database? 1. Discuss the use of databases and data communication technologies 2. List three similarities between all three bookstores 3. List differences between all three bookstores D. What are possible issues with the bookstores database? 1. Discuss database issues that each bookstore potentially may have 2. Discuss possible database solutions to these issues 3. Discuss any security related issues a. legal and privacy aspects of their website and business E. Discuss if the bookstore meeting its business objectives 1. List each bookstores business objects 2. Discuss whether each business is meeting their objectives and how? F. List the vision and mission of the bookstores. III. Conclusion References Peterson, V. (2015). Barnes & Noble’s booksellers-"the world's largest bookstore". Retrieved from http://publishing.about.com/od/BooksellersAndBookselling/p/Barnes-And-Noble-Booksellers-The-Worlds-Largest-Bookstore.htm Barnes & Noble’s selects Accenture and initiate systems. (2007). Retrieved from https://newsroom.accenture....

Words: 340 - Pages: 2

Premium Essay

Bookstore Outline

...objectives. Our first assignment related to the bookstore project was to identify the hardware and software as well as the databases and data communications. We were tasked with how the bookstores use the different databases, such as what information is stored, and what are possible issues. Our team identified several databases, as well as software and hardware used for the bookstore as part of the bookstore project research. Week Two Objectives were to describe how and when to use databases in business; determine data communications needs based on business function; and use Microsoft office to accomplish business objectives. There were several database options that our team had to choose from in order to suit our bookstore project; our team decided on what we thought would be the best and least expensive to suit both our project and budget. Our team also went with the best options that pertained to software and hardware for our book store project. There were many options amongst the providers, but we decided to go with options that would the best financial benefit, and offered longevity. Week Three’s objectives were as follows: determine how and when to use Internet technologies in business; determine collaboration tool needs based on business functions; write a discussion about whether the companies are meeting their business objectives; use Microsoft Office PowerPoint to accomplish business objectives. We were tasked with how the bookstores utilizes various software and hardware...

Words: 1289 - Pages: 6

Free Essay

Outsourcing

...Applying Information Security and SDLC to Business Nusiaba Abbas, Jason Jernigan, Patrick Kein, & Natasha Scott BIS/320 October 8, 2012 Gordon Hodgson Barnes & Noble Who and what is the bookstore? What is their mission? Barnes & Noble offers a huge selection of textbooks, newspapers, magazines, music, DVD’s, and EBooks. They are the Internet’s largest bookstore offering an easy way for customers to find precisely what they are looking for in books. Barnes & Noble offers over 100,000 unique book titles per store and customers can walk into the store at anytime looking for titles not on the bookshelf. What products do they sell? The Largest book store of all is Barnes & Noble.com. This website ships faster than any other online bookseller. Barnes & Noble has dedicated time and money to meeting business objectives successfully. Books created to include audio books, MP3 audio books, award winners, and bargain books. To offer millions of books, EBooks, Nook tablets from a network of trusted sellers. All purchased at a convenient price that’s secure. Who are their customers? Barnes & Noble is the destination for book lovers offering an array of content. B & N studio offers hundreds of video author interviews, Emmy-winning documents and features a weekly book show. Anyone looking for best children’s books, videos, music, DVD, Blue ray stores makes it a great...

Words: 892 - Pages: 4

Free Essay

Research

...SWOT Analysis Assignment Sam Weller’s Bookstore Marketing 1030 B. Ledesma Oct. 26, 2011   Brief History Sam Weller’s Bookstore was founded in 1925 by Mormon converts Gustav and his wife Margaret Weller, who emigrated from Germany to Salt Lake City. The bookstore started off as a used furniture store, "Salt Lake Bedding, Furniture & Radio Shop," and after a large purchase of used books and a larger location, it became known as Zion’s Bookstore and mainly sold second hand books about the Latter Day Saints. It is now owned and operated by Tony and his wife Cathryn Weller, who comes from a library background. Tony started working at the bookstore since the age of 10 but fully committed himself to it in the 1980s. Between the 1940s and 200s, Sam Wellers operated half a dozen stores throughout the valley, most being new bookstores and even including a textbook store. The current owner, Tony Weller, boasts a literary background and has held positions in The Downtown Alliance, The Chamber of Commerce, The Vest Pocket Coalition and the Salt Lake Downtown Merchants Associations, of which he is a former President, and was also on the board of the Intermountain Independent Booksellers Associations. Products & Services Sam Weller’s Bookstore offers traditional bookstore services; new books, used books and rare books. The owner also operates an appraisal service in the rare books department. The business also offers a café to relax and enjoy reading and polite conversation. The...

Words: 1160 - Pages: 5

Free Essay

Bis/320 Week 3 Weekly Reflection

...Reflection - Outline I. Introduction - Carl A. State purpose of paper, introduce book stores… Amazon is growing and leading sales with a strategy that appeals to non-bookstore buyers. BAM is struggling, while Barnes and Nobles appears to be shifting to more of an Amazon like strategy. All of the companies utilize internet websites. B. Comparison of sales in 2011...Amazon leads the way with $7.96B (excludes electronics, services - books, includes books, music, DVDs) and is growing. Barnes and Noble was second with $4.36B. BAM trailed with $468MM on declining sales. C. Introduce software programs utilized D. Introduce hardware. II. Amazon – Veronica A. History and Mission - Founded in 1994 as Cadabra by Jeff Bezos with global headquarters in Seattle, Washington. Although, its profits were slow coming at the beginning, as planned by Bezos, the annual sales in 2011 were of $48.08 billion with a customer based on 30 million customers worldwide (Marketing Teacher, 2012).In July 1995, the first book sold on Amazon.com was Douglas Hofstadter's Fluid Concepts and Creative Analogies: Computer Models of the Fundamental Mechanisms of Thought (Amazon Media Room, 2012). B. Software utilized - Linux,Oracle,C++,Perl, Mason,Java, Jboss, Servlets (Stack Exchange, 2012). 1. Communications 2. Databases 3. Security C. Hardware - Hardware used includes SCSI / SATA RAID internal storage are some of the software, security and hardware utilized by Amazon.com III. Barnes...

Words: 952 - Pages: 4

Premium Essay

Amazon.Com Evolution Paper

...realize that their business changed over time. We have research if Amazon is moving away from its core competency, competition with other companies, the use of its database, and how Amazon uses e-business and e-commerce for B2B and B2C. Amazon is a world known online retailer company. Jeff Bezos discovered Amazon in 1994. He launched the online store a year later. WOW! What a well written business plan. “The company began operating as an online bookstore under the name Cadabra.com, from the word abracadabra. Bezos quickly changed the name because it sounds too similar to cadaver. He renamed the company "Amazon" after the world's most voluminous river (Amazon.com, N.D.).”Amazon has not driven away from its core competency. The online retail store has just broadened their horizon. In the beginning, the company started off with Amazon existing as an online bookstore, but Amazon is now selling more products. The consumer can purchase books, electronics, clothing, furniture, movies, food, toys, and much more. The company had meetings in a garage, to Barnes and Noble for future meetings. The owner wanted so much more than just an online bookstore. It seems like he wanted Amazon to be a one stop shop. Today that is exactly what it is. The online bookstore was able to put forth countless times of more what competitive bookstores or catalogs could offer because lack of inventory stock in the local store. When Amazon first came to existence, one of the first promises they made was to revolutionize...

Words: 1117 - Pages: 5

Premium Essay

Casereports

...ESLITE  IN  SINGAPORE   1   Eslite Profile: One of the best bookstores in Asia Eslite was selected as one of the best bookstore in Asia by Times Magazine in 2004, and it was awarded "the most influential design award" by the Hong Kong Design Center. The founder was Mr. Wu Qing-You. He establishes this bookstore in 1989. His purpose of founding this organization is to see cultures and arts cultivated as the economy grows. As a result, this bookstore is operated based on arts and culture, hoping to enhance the diminishing humanities in Taiwan. Eslite now owns 48 branches, and is highly experienced in establishing them. The number of employees is about 1,200, and annual sales are about 1 billion dollars. It not only provides people with a comfortable atmosphere to read, but also blend in the element of fashion and trend into the bookstore. In spite of the bookstores, Eslite also owns 2 stationary stores, 5 concert halls, and 2 children bookstores. Eslite is well operated by compound management, including publishing, art exhibitions and even Tearoom. Because of its positioning and targeting customers, most of the branches are located in the urbanized areas. In 2012, Eslite established the first overseas branch in Causeway bay, Hong Kong. It is a spacious and quiet bookstore with more than 230 thousand books. It’s now the biggest bookstore and the one with most book collections in Hong Kong. Moreover, it will soon open in China at Soochow 2014. Assessment of Potential...

Words: 2915 - Pages: 12

Premium Essay

Systems Development Life Cycle

...Don Cluff, Krystal Green BIS/320 February 17, 2014 Lisa Ricks I thought I would change course a little and discuss how I would implement the Systems Development Life Cycle (SDLC) in my bookstore if I were the owner of Book Worms, our local faith-based bookstore. Book Worm currently has a limited amount of inventory on hand. It relies on a catalog service for some of its product offering. This product is not stocked in the store but is accessed through the bookstores web site. This is the only bookstore in a 120 mile radius, and yet they concentrate on a small selection of religious books. To broaden the client base of the Book Worm bookstore, I will utilize the systems development life cycle to explore new systems that would allow me to broaden the scope of my product in a manner that would increase gross margin. The first step in SDLC is to define the system that needs to be implemented. This system as designed by our meager staff of experts will include software that will allow the Book Worm to work in conjunction with other book sellers such as Squadron, Waldpole, Motorbooks, etc. These book sellers will often allow access to their inventory by brick-and-mortar stores that are stockiest of their titles. Once this partnership is established, the available inventory of the bookstore would increase many fold (Kroenke, 2012). The online and kiosk ordering system would have several requirements. The second step in SDLC will be to analyze those requirements and refine the...

Words: 630 - Pages: 3

Premium Essay

Week 3 Reflection

...Contrast of Popular Online Bookstores * Use of hardware and software * * “Common Hardware technologies used in business include: Desktop computers, laptops, mainframes, MS Windows, Mac OS, Unix, Linux, servers, web servers, and blade servers. Common Software technologies used in business include: enterprise applications, productivity and Office Applications, communication and information-sharing software, and entertainment and Media development software.” (Management Information Systems, 2013). * * The most popular software that is used amongst businesses are Accounting software called Intuit QuickBooks Pro, Backup and recovery software called Mozy, Blogging Software called WordPress, Calendar software called Sunbird, Collaboration software called Vyew, Collaboration and Office Suite software called Google Docs, CRM software called Salesforce.com, and Database software called FileMaker Pro. For the popular hardware used in business are servers, workstations, laptop and desktop computers, network switches, routers, cell phones, blackberries, PDA’s, GPS devices and many more. * * Use of databases and data communication technologies * * Besides the high importance of software and hardware that is used in virtually every business, databases and data communication technologies is just as important. There are main elements that make up databases and data communication for all three of these business: * Database Processing: is the system...

Words: 1523 - Pages: 7

Free Essay

Business

...big loss in textbook sales at the University’s bookstore. A group from the University Students Organization researched textbook prices at three outlets. In general, prices of textbooks have been increasing which has become a major burden to all students of all majors. This increase makes a difficult situation for students already trying to pay university tuition and housing bills. Many students have jobs to help pay the costs, so an increase in the price of textbooks is a cause for concern. The University Bookstore is convenient for some students on campus, it can be time saving for some who are trying to get their books on time before semester classes begins. The University Bookstore may be competitive to other bookstores on campus when it comes to pricing, but it will not be as competitive as online book prices. We are going to take a look at textbook prices for ten different courses at two online outlets, and compare them to a third outlet which is the University Bookstore. Pricing Comparison New books Table 1 below is a comparison of textbook prices, the University Bookstore charges the highest price for all ten books. Half.com charges the lowest price for seven out of the ten books, while Amazon.com offers the cheapest price for the remaining three textbooks. In total, five textbooks – in this example for a student taking the courses astronomy, computer, economics, history, and English – cost $544.95 at the University Bookstore. To buy those books on Amazon.com, the total would...

Words: 1259 - Pages: 6

Premium Essay

System and Analysis

...General | Project Name: | Bookstore | Project Sponsor: | Jacqualine De Sauza | Project Manager: | Afiq | Business Case Statement | [Why is the project being undertaken? What is the background of this project? What is the cost/benefit of the project?]This project has being undertaken is because the client ha stated the problem that they are having problem when they store the books id … they have to do manually like write in a record book.an they are having difficulties when they want to retrieve data .A computer Information System (IS) is a system composed of people and computers that processes or interprets information. The term is also sometimes used in more restricted senses to refer to only the software used to run a computerized database or to refer to only a computer system. The cost of this project are about 5 month including the maintainance employees salary are RM 3600.00, Operation fees are RM15000.00 and the materials is about RM6000.00 | Problem Statements | 1. | [What are the specific problems the team will address in this project?]New user have to be train to use this system | 2. | Have to maintain the system | 3. | Have to find bigger bookstores to use this system | 4. | Language- the user must understand the language that the system use for example if the employer take workers who do not know English properly it will be hard for that employee to understand what the sytem ask to and in another way to | 5. | The cost is high | Goal...

Words: 380 - Pages: 2

Premium Essay

Business Information Systems

...Business Information Systems BIS/219 August 17, 2010 Xuan Yu In this team paper we will be discussing the strategies of Amazon.com to see whether the Internet icon is moving away from being the number one leader online. We will be showing different areas to see if Amazon.com is using the right strategy to compete with Google and Microsoft. We find the different issues concerning the database and data management with Amazon.com. Finally we will be discussing the uses of e-business and e-commerce for the B2B and B2c. As of January 2010, Amazon.com was considered the largest online retailer in the United States. Amazon was launched in 1995 by its founder Jeff Benzo. Benzo’s original idea was to create an online bookstore. Compared to traditional bookstores or even mail-order systems, an online retailer could carry a far greater quantity of books for sale. Just like most businesses, even the traditional bookstores, Amazon expanded its business past just books and began adding an array of items; ultimately making its way to selling almost anything possible. Stockholders of Amazon.com, knew the turn over would be a rather slow process with the gradual growth of online sales, but none-the-less they would expect a profit. It took Amazon until its fourth year to produce any revenue and finally to hold its ground as an online retailer. This slow progress made Amazon move away from its original concept...

Words: 1145 - Pages: 5

Free Essay

Northlake Bookstore

...Northlake Bookstore: Benchmarking for Performance Evaluation By: Manuel Garza Hugo Hinojosa Graciela Rodriguez Jose Garcia Alejandro Arizpe Carlos Arizpe Summary of Facts Upon assessment of the FY2004 financial information, Wendy Wiley, Northlake Bookstore’s manager, identified the first ever drop in book sales over the previous quarter. After identifying the drop in sales, Wendy turned to Chuck Irwin, the Vice Chancellor of Finance for Northlake University. He mentioned that Wendy should conduct a benchmarking analysis in order to identify the deficiencies that led to the drop in book sales. In addition, Chuck also asked Wendy to develop a set of short-term performance goals and measurements for future evaluations. Northlake is a private university located in the Midwest U.S. Annual enrollment is estimated at 12,700 students. Northlake is overwhelmingly comprised of undergraduate students. Over 60% of the university’s revenues come from student tuitions, with the majority of the remaining 40% stemming from donations and gifts. Chucks, the Vice Chancellor, is worried that the donations and gifts have decreased dramatically during the current year. He believes this is due to the current uncertain economic conditions and the stock market’s erratic performance. Wendy has been the bookstore’s manager for 7 years now. She previously worked as a Wal-Mart sales manager where she acquired15 years of experience in...

Words: 2655 - Pages: 11

Free Essay

Hi This Is Ool

...Bookstore Inventory Project Description: In the following project, you will open a database containing the inventory of a bookstore, create a new table in which to store publisher information, add records, and then sort the table. You add a record using a form and print a report. You apply a filter by selection to a query and a filter by form to a table and save the results for both filters. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Start Access. Open the downloaded Access file named exploring_a01_grader_h1. | 0 | 2 | Create a new table in Design view. Add the following field names to the table: PubID, PubName, PubAddress, PubCity, PubState, and PubZIP (in that order). Accept Short Text as the data type for all fields. | 12 | 3 | Set the PubID field as the primary key of the new table. Save the table using the name Publishers and then view the table in Datasheet view. | 8 | 4 | Add the following records to the Publishers table: PubID PubName PubAddress PubCity PubState PubZIPKN Knopf 299 Park Avenue New York NY 10171BB Bantam Books 1540 Broadway New York NY 10036PH Pearson/Prentice Hall 1 Lake Street Upper Saddle NJ ...

Words: 497 - Pages: 2

Premium Essay

Case Study

...Case Study Best-Book-Buy Online Bookstore Requirements Specification Document (By Henrique Paques, Leo Mark and Shamkant B. Navathe) 1. Introduction The purpose of this case study is to present a data-intensive application for which a database can be designed. It is described with sufficient degree of detail so that the application can be implemented in languages like Java or C using ODBC or JDBC connectivity to the relational database. This case study is an illustration of the typical project we have been using to teach an undergraduate class in database design that covers essentially the first 16 chapters of the textbook at Georgia Tech. The user interface is defined in screen format – these screens can be implemented using Visual Basic or Java as needed, or a simpler version of the interface using simple text menus may be implemented. There are a few reports included in the application specification. They are for illustrative purposes and may be modified as well. The methodology to be followed uses conceptual design in the Entity Relationship Model (Chapter 3), followed by a mapping of the ER schema into the relational schema (Chapter 7). The application is broken into a number of tasks and the inputs and outputs are related to the tasks by means of an Information Flow Diagram. Students should use Chapter 12 to understand the overall process of database design used for design of large databases. A design methodology is developed during the discussion of this...

Words: 5909 - Pages: 24