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?
Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.
Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus.
Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
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.