Database Design Homework Help

Database Design may be the procedure for creating a detailed data model of a database. This logical data model consists all of the required logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which could after that supply to produce a database. A completely attributed data model consists detailed attributes for each entity.

The term database design may be used to explain numerous parts of the design of an overall database system. Primarily and many correctly, it may be thought of as the logical design of the base data structures used to store the data. In the relational model these are the tables and views. In an object database the entities and relationships map directly to object classes and named relationships. However, the term database design could also be used to apply to the overall process of designing, not just the base data structures, but also the forms and queries used as part of the overall database application within the Database Management System (DBMS).

The Design Process

The Design Process Includes The Following Steps:

1. Determine the purpose of your database :- This can help prepare you for the remaining steps.
2. Find and organize the information required :- Collect all the kinds of information you might want to record in the database, such as product name and order number.
3. Divide the information into tables :- Divide your information items into major entities, for example Products or Orders. Each subject then becomes a table.
4. Turn information items into columns :- Choose exactly what information you need to store in each table. Each item becomes a field and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
5. Specify primary keys :- Select every table’s primary key. The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID.
6. Set up the table relationships :- Look at each table as well as choose the way the data in one table is related to the data in other tables. Include fields to tables or create new tables to clarify the relationships, as required.
7. Refine your design :- Evaluate your design with regard to mistakes. Produce the actual tables and add a few records of sample data. Observe if you're able to obtain the results you want from your tables. Make adjustments to the design, as required.
8. Apply the normalization rules :- Utilize the data normalization guidelines to determine in case your tables tend to be organised properly. Make adjustments to the tables.