Menu
It is a bit strange to me about database schemas sample which I think most of the projects will need to design a database for it. but when I try to find sample online, it is really rare (eg. full database schema for Inventory Management, School Management, HumanResource management). I know that each database design is depends on the project requirement, but I don't think it is much different.
I just wonder why there is so few people kick it online as other source code.
Could anyone pointing me out where to get it or any advice?
Thanks in advance
741
A schema can belong to only one database whereas a database can have one or multiple schemas. There are no restrictions on the number of objects in a schema.
A good database design is, therefore, one that: Divides your information into subject-based tables to reduce redundant data. Provides Access with the information it requires to join the information in the tables together as needed. Helps support and ensure the accuracy and integrity of your information.
For example, in the Oracle Database product, a schema represents only a part of a database: the tables and other objects are owned by a single user. Note: In SQL, a view is a virtual table that is based on the result-set of a statement. A view contains both rows and columns.
Schema is of three types: Logical Schema, Physical Schema and view Schema. Logical Schema – It describes the database designed at logical level. Physical Schema – It describes the database designed at physical level. View Schema – It defines the design of the database at the view level.
This must be the ueber-list on database schemas. And here's an interesting reading list on Amazon. I can recommend the Len Silverston books. They will get you started.
62
There are plenty of database schemas out there, I'd say.
SQL Server 7/2000 schipped with "pubs" and "Northwind" which you can still download from CodePlex.
SQL Server 2005 shipped with AdventureWorks, which is quite extensive and available in various versions (OLTP, OLAP, Light) - also available from CodePlex.
Many bloggers have sample databases they use for their blogs and their screencasts, e.g. Rob Bagby has one for school data and one for a winery on his blog.
There are several more (aimed at finally getting rid of using the notorious Northwind database for demos) on Codeplex.
Marc
35
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
