Once you have the list of Business requirements ; you come up with a logical layout of the application using the High level document. using these documents functional specification documents is frozen. for logical database design we use the functional specification, High level design and then the business requirements list.
Based on the high level design we create place holders ; these place holders can be referred to as columns; now group these place holders all similar ones are grouped as a table.... and so on...
then you need to establish relationships between them; make sure it conforms to rdbms standards, then normalize the data etc etc...
The best would be give me a requirement which you feel comfortable and will help you to design a database... lets work together :)
* Logical database design: * ensuring, via normalisation procedures and the definition of integrity rules, that the stored database will be non-redundant and properly connected; * Physical database design: * specifying how database records are stored, accessed and related to ensure adequate performance. What is logical database designerThe major role of logical database design is to transform the combined, reconciled data specifications into basic or atomic elements following the well established rules for well structures data specifications. With a complete logical database design in place an analyst begins to specify the logic of the particular computer programs and queries needed to maintain and report the database content. The person who maintain or responsible to perform the above task is known as Logical Database designer.
Logical database design is the process of designing the database at a conceptual level as opposed to a physical level. There are many advantages of conceptual database design, such as the ability to design the database without having to commit to a particular database management system, to produce a document that is readable and understandable to everyone in the company (not just the database person) and to produce an overall design document that can be saved as a part of the documentation of the database for future enhancement, maintenance and support work. Logical database design produces documents for use in the same way that architects produce blueprints for building purposes.
normalized relations
Conceptual database design is the process of constructing a model based on the enterprise. Logical database design is the process of constructing a specific data model. Physical database design is the process of producing of the database on the secondary storage.
What are the six phases of database design? Discuss each phase.Database design phases are:1. Requirements collection and analysis.2. Conceptual design.3. Logical design (data model mapping).4. Physical design.
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
Peter P. Chen has written: 'A logical database design framework'
There is only one meaning of the words database design. Data base design means the process of creating a very detailed data model of a database. It is used for a database, of course. Hello, Database design is part of system development, it is the process of producing a detailed data model of a database. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Databases are used everywhere in the world of web development. - conceptual database design - logical database design - physical database design Database designing , website designing & development requires proper knowledge about that. If anyone wants more information about that can communicate with the Hvantage Technology. I also visited this site it has all related information.
A logical database is the structure of data. It is the different pieces of information and the relationships between them.
tablespace,segment,extent,oracle blocks.. are the logical schema of a database
The logical database is how the data is percieved in the tables, the way the data is actually stored on the storage medium is the physical view of the database.