Preview

Hfkj

Better Essays
Open Document
Open Document
1118 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Hfkj
User Stories – Book Shop
The manager of a small book shop has asked you to design and implement a database that centralizes information so that it is easier and more efficient to man-age inventory and track orders and sales. The shop handles rare and out-of-print books and tends to carry only a few thousand titles at any one time. Currently, the manager tracks all of the sales and inventory on paper. For each book, the manager records the title, author, publisher, publication date, edition, cost, suggested retail price, and a rating that indicates the condition of the book. Each book is assigned one of the following ratings: superb, excellent, good, fair, poor, or damaged. The manager would like to be able to add a description to each rating (just a couple of sentences), but the description should not be required. The information about each book must include the title, author, cost, suggested retail price, and rating. The publisher, publication date, and edition are not always available. If the year a book was published is available, the year will never be before 1600. And for purposes of the new database system, the publication date will never fall after the year 2099. Because these books are rare, each title must be tracked individually—even if they are the same book (identical title, author, publisher, publication date, and edition). Currently, the manager assigns a unique ID to each book so that identical titles can be differentiated. This ID must be included with the book information. The book ID assigned by the manager is an eight-character ID made up of numbers and letters.
The manager also maintains limited information about each author whose books the store has carried or is carrying. The store might carry more than one book by an author, and sometimes more than one author will have written a book. The manager currently maintains information about approximately 2500 authors. The information includes the author’s first name, last name, year of birth, and

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Ch1 Ws Student

    • 235 Words
    • 6 Pages

    Chapter 1 - Managerial Accounting and Cost Concepts Exercise 1-5 1. Traditional income statement Redhawk, Inc. Traditional Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expenses Administrative expenses Net operating income 2. Contribution format income statement Redhawk, Inc. Contribution Format Income Statement Sales Variable expenses: Cost of goods sold Selling expenses Administrative expenses Contribution margin Fixed expenses: Selling expenses Administrative expenses Net operating income Exercise 1-11 1.…

    • 235 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    Jlkjklj

    • 7511 Words
    • 31 Pages

    Share gains to drive above-industry growth On December 19, we estimate ACN to post 1Q13 revs of $7.34bn (+3.8% Y/Y, +6.8% cc) and EPS of $1.06. With the IT spending environment remaining mixed as 2013 nears (early indications suggest flat budgets next year), we continue to believe that ACN will continue above-market growth from share gains through transformational engagements and industry-specific BPO growth. The key for further upside in ACN shares will be a clear bottoming of Consulting with an expected rebound looking more likely in 2HFY13. We believe ACN will reiterate FY13 guidance, potentially shading the high end of its EPS range. We maintain our Buy rating and $75 target price.…

    • 7511 Words
    • 31 Pages
    Powerful Essays
  • Powerful Essays

    Hjgyjjyruh

    • 1203 Words
    • 5 Pages

    The aims of Selfridges finance department are to keep records of financial activities in order to provide managers with information and help create financial plans. The finance area is the most important function in the business. This is because businesses need a regular stream of income to pay the bills. Finance staff record all the money earned and spent so that the…

    • 1203 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Kjkj

    • 625 Words
    • 3 Pages

    Sitting in a NEW 205 class on the first day of the spring semester, Kati DeCaire looks like just one of the many fresh-faced college students ready to take on the world. But DeCaire is not your typical Syracuse University underclassman. Unlike many of her peers, she has already had life experiences far from typical for someone her age. She has suffered hardships and made tough decisions that have taken her on an incredible journey.…

    • 625 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hjfdh

    • 727 Words
    • 3 Pages

    * When the Japanese left China at the end of WWII, cooperation between the Nationalists and Communists broke off. That is when the Communists took over China and war had evolved yet again between the two.…

    • 727 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hjgk

    • 292 Words
    • 2 Pages

    • Inter-dependent decision-making: Inter-dependence means that firms must take into account the likely reactions of their rivals to any change in price, output or forms of non-price competition.…

    • 292 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The third sentence should tell how many pages the book has and the name of the publisher.…

    • 934 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Sdfkj

    • 969 Words
    • 4 Pages

    Please answer the following ten (10) questions in preparation for our class discussion. Make sure that you type up your answers and give them to me before the discussion. Keep another copy for yourself so that you can refer to it during the class discussion. Important note: I will NOT accept handwritten answers or responses emailed me to after the class discussion.…

    • 969 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    In my essay I am going to write about issue concerning to ugly people. Are they should be forced to undergo plastic surgery? In my opinion, definitely yes! It is really hard to be ugly person. Such person experiences many sad things. I will try to prove, that forcing ugly people to do something with their appearance, is good for society.…

    • 253 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    By referring to any ONE (1) Caribbean religious grouping, show how its beliefs contribute to this feature of society. Relevant theoretical perspectives must be employed in the response.…

    • 1689 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    LGBT

    • 29584 Words
    • 113 Pages

    respected companies. Aspatore annually publishes a select group of CLevel executives from the Global 1,000, top 250 professional services…

    • 29584 Words
    • 113 Pages
    Powerful Essays
  • Good Essays

    Hjh.Kjk

    • 818 Words
    • 4 Pages

    “Thou shalt believe all that the Church teaches, and shalt observe all its directions, Thou shalt defend the Church, Thou shalt respect all weaknesses, and shalt constitute thyself the defender of them, Thou shalt love the country in which thou was born, Thou shalt not recoil before thine enemy, Thou shalt make war against the Infidel without cessation, and without mercy, Thou shalt perform scrupulously thy feudal duties, if they be not contrary to the laws of God, Thou shalt never lie, and shall remain faithful to thy pledged word, Thou shalt be generous, and give largess to everyone, Thou shalt be everywhere and always the champion of the Right and the Good against Injustice and Evil.” (Gautier 's Chivalry 2) Truth, honor, generousness and courtesy are some models of how a Knight should act. Chivalry is a quality, which is resulted in the following short stories: “Sir Gawain and the Green Knight”, “The Wife of Bath” and “Le Morte D’Arthur.” All these short stories show the true meaning of chivalry by truth, honor, generosity, and courtesy.…

    • 818 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Effective Communication

    • 1768 Words
    • 8 Pages

    Pierce, Jon L. & Newstrom, John W. (1996). The manager 's bookshelf: A mosaic of contemporary views, (4th Edition). New York: HarperCollins College Publishers.…

    • 1768 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    Hhjgs

    • 2536 Words
    • 11 Pages

    Gerdmans Inredningar, is one of the leading mail-order companies in Scandinavia. The purpose is to get a better understanding about Gerdmans, because they are our partner company during the education of International Sales and Marketing.…

    • 2536 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    Hfsjdfjs

    • 255 Words
    • 2 Pages

    This game uses the Japanese language and has little use of English. Written Japanese makes use of three main systems: kanji, hiragana, and katakana. Kanji refers to Chinese characters used in written Japanese. School children are taught the 1,945 regular kanji (identified by a 1981 governmental decree) used in "official" communications (there are thousands of other kanji in use).…

    • 255 Words
    • 2 Pages
    Satisfactory Essays

Related Topics