SQL New Library Project

Page 1 of 3
CIS 255 Project: instructions and rubric
 You’re going to be tasked with designing a relational database for a “new library” in town
 It will include the following:
o A proposal,
o Business rules,
o Attribute names and definitions,
o An ERD (Entity-Relationship Diagram),
o Should be implemented in Oracle/SQL
 Comments, comments, comments!
 If I leave the company and YOU get hired to take my place, wouldn’t
your life be made easier if my code/work is fully documented?
 Tables as required
 Relationships between those tables
 Constraints on data and proper data types
 Saved queries which I can run against the data you’ll populate your DB with
o Cardinalities
o Any required primary and foreign keys
o If required, super and sub-types
o Bother inner and outer joins
Specific Instructions:
 Part 1: The story of the business
o Why would a library WANT an electronic database system?
o One-to-two sentences about the mission of the library
o One-to-two paragraphs to describe the high-level processes you will employ
o One-to-two paragraphs to describe (in more detail) the processes, data, and business
o In short, think about the NON-TECHNICAL “stuff” that goes on at a library and write this
in such a way that someone who has never heard of a library can read this and
 Part 2: The business rules:
o If you were the librarian or a patron of the library, what rules would you have to follow?
o Rules for borrowing/returning books?
 What if someone returns their items late?
 Can a patron borrow additional items if I owe a “late fee”?
o How does a patron get a library card?
o How are new books, periodicals, etc. added to the library’s inventory?
o How are old/damaged items removed from the library’s inventory?
o Can ANYONE get a card at your library, or must they live in an approved geographical
 Part 3: The attribute names and definitions
o The library has books, DVD’s magazines, etc., correct?
 How are those items categorized?
 What information must the database have to “keep track of” those items?
Page 2 of 3
 What information must the database have so patrons can search for items?
o Does your library have multiple locations?
 Part 4: A detailed Entity-Relationship Diagram (ERD)
o This must reflect all the business rules (part 2) AND the entities (part 3)
o Should follow “best practices” for ERD design
o Should show proper relationships, keys, and cardinalities
 Part 5: the SQL/Oracle statements:
o To create tables as required
o The INSERT statements to get a “reasonable amount” of data (at least 100 items across
all entities)
o The proper keys defined
 Part 6: the queries that you will run to get data returned to you
o Make proper use of clauses such as
 IN,
o Two functions
o One calculation
o An INNER JOIN on at least three tables
o Your queries should be properly documented in a way that someone who is covering for
you can read them and understand the purpose
Grading rubric:
 This project will be worth 30% of your overall grade in this course.
 The project is divided into SIX “categories”:
o The story of the business: 5% of the overall grade
 Well-written
 Consistent with, and complementary to the deliverable
o The business rules: 5% of the overall grade
 Well-written
 Consistent with, and complementary to the deliverable
o Attribute names and definitions: 20% of the overall grade
 Easy-to-read
 Consistent with notations in the slides, lectures, and Internet searches
 Comprehensive
o The ERD: 20% of the overall grade
 Easy-to-read
 Contains all entities and relationships
o Data and table creation: 25% of the overall grade
 Easy-to-read
 Contains all entities and relationships
 Has appropriate constraints
 Reasonable amount of data
 Referential integrity enforced
o Queries: 25% of the overall grade
Page 3 of 3
 Should be commented in “simple language” so that your replacement can read
them and understand

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Get 20% off your first order