WhatABook: Design

1. Using UMLet, create an ORD based on the provided business rules (refer to the requirements document)
2. User fields
   • user_id
     • INT
     • NOT NULL
     • AUTO_INCREMENT
     • PRIMARY KEY
   • first_name
     • VARCHAR 75
     • NOT NULL
   • Last_name
     • VARCHAR 75
     • NOT NULL
3. Wishlist fields
   • wishlist_id
     • INT
     • NOT NULL
     • AUTO_INCREMENT
     • PRIMARY KEY
   • user_id
     • INT
     • NOT NULL
     • AUTO_INCREMENT
     • FOREIGN KEY
   • book_id
     • INT
     • NOT NULL
     • AUTO_INCREMENT
     • FOREIGN KEY
4. Book fields
   • book_id
     • INT
     • NOT NULL
     • AUTO_INCREMENT
     • PRIMARY KEY
   • book_name
     • VARCHAR 200
     • NOT NULL

   details V

   • VARCHAR(500)
   • author
     • VARCHAR(200)
     • NOT NULL
5. Store fields
   • store_id
     • INT
     • NOT NULL
     • PRIMARY KEY
   • locale
     • VARCHAR(500)
       • this will be a string field that will include the street address, city, state, and zip
     • NOT NULL
6. Save the ORD as an image

Deliverable

1. Place your image into a word document and include your name, date, and assignment.
2. Save your document as <your-last-name>-<assignment-name> .docx.

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."

“Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!”