Databases are used in so many ways on so many websites. They are used for small tasks and large distributed networks scaled to handle millions of transactions per day. Sometimes we need a little help, a little push in the right direction in order to create a properly designed and normalized database. Thankfully, there are sites like DatabaseAnswers.org that provide help from "getting-started tutorials" to "database models."
There are over 500 free database models at this website. They are all viewable in data model form and can be saved as an image or printed. You are also able to request an access database for any of the data models available by simply emailing and asking for one. The data models span many different categories from customers to bookstores to catalogs, and the list just goes on. I have listed the top 20 data models below.
Top 20 Data Models
- Libraries and Books
- Inventory Control for Retail Stores
- Hotel Reservations
- Video Rentals
- School Management
- Clients and Fees
- CD Collections
- Customers and Invoices
- Payroll
- Apartment Rentals
- Customers and Services
- ERP
- Car Sales
- Customers and Addresses
- Driving Schools
- Health and Fitness Clubs
- Hospital Admissions
- Inventory of Files in Boxes
- Sports Clubs
- Airline Reservations
The creator of all of these database models runs multiple database companies; one is in the UK; the other is in the US. He has also created data models that are included in Microsoft SQL Server 2005 Express. He offers his reason for providing these saying, "I design these Data Models for free to give something back to the Database community that has provided me with a good (and interesting) living for the past 15 years" (DatabaseAnswers.org). Be sure to check these out and show some love for all the hard work that went into creating these and offering them for FREE!
10 comments
Post your own
[...] Sitio con más de 500 modelos de base de datos [ENG]www.webmastersbydesign.com/2008/08/04/library-of-over-500-fr… por pfuitufel hace pocos segundos [...]
[...] this resource through Webmasters by Design website) Posted in SQL. Tags: [...]
So these are resources for christian webmasters? Have any suggestions of good resources for non-christian webmasters because this looks useful but I am not a christian.
Rick, although you may not be a Christian, you are more than welcome to use any information on the site that you find useful.
Just a quick look at the inventory model shows that the maker has never worked for a retail chain. He assumes that the price of a product never changes. He also has no idea of layered inventory pricing. That’s just off the top of my head. I wouldn’t seriously consider his “models”.
[...] | webmasters by design Estas leyendo “500 modelos entidad relacion para bases de datos” publicado el Mie, 06 [...]
[...] Library of Over 500 Free Database Models | Webmasters by Design (tags: webdev webdesign web tutorials tutorial) [...]
[...] Library of Over 500 Free Database Models “There are over 500 free database models at this website. They are all viewable in data model form and can be saved as an image or printed. You are also able to request an access database for any of the data models available by simply emailing and asking for one.” [...]
what is database models
I have to show my love and gratitude for the work you have done to help new database designers such as me. Great work!!!!!