A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing


  • one year ago

I am required to create a database in visual studio for an online book rental system. What are the things to include in the table?

  • This Question is Open
  1. e.mccormick
    • one year ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Well, what do you want to store for a book rental? What do they ask you any time you rent something? Each table is generally a related set of things. For example, a "Customer" table would likely have name, address, phone number, etc. For a rental place they might have number of times late or other rental specific things. This would be different from the table of items in stock and items rented out. Each customer would have an ID number. That would be a master key for that table. Then, any time someone rents a video out it is listed as rented to that ID number. Typical reports for this sort of thing would be sales, lates, release dates (so you know when to put out the new stock) and so on. That should give you some ideas to work with.

  2. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...


  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.