answersLogoWhite

0

How can I design a good database?

Updated: 8/16/2019
User Avatar

Robabebrahimi

Lvl 1
16y ago

Best Answer

This is a very broad question. I'll try to present different areas for you to consider when designing a database.

1. What is the database program and what is the OS it will reside on?

2. What is the scope of the database? Small (100 tables), medium (500 tables), large (1000+ tables and maybe a Terabyte of data?)

3. What type of data needs to be stored?

4. You'll need to know the hierarchy, related data (to make relationships between the tables), nature of the data within the tables to properly size the tables for future growth. Now, if you don't have all the up-front information, you can always create the database with what you do know. However, realize that later you may have to restructure, recreate the tables larger and copy the data or it may be easier just to recreate the database. If you need to do this, you can export the data if you have any that needs saved. If on the same node, you can do this table to table or by flat files. Table to table, you will have to disable auditing and any constraints, they reenable when finished. If you insert by flat files, it is faster and you will not have to disable. There is a lot to designing, updating and maintaining a database.

User Avatar

Wiki User

16y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

A good database is nothing but something non-redundant and integrated. To design a good database one must know what is his/her requirements what tables they want , fields (attributes), relationship between them. Keeping all the requirements in mind one can design a good database design.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can I design a good database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What a good database design require?

A good database design requires that the Data is conveniently and efficiently stored. Also the data can be easily stored and maintained.


Design a Web Database?

form_title=Design a Web Database form_header=Hire a developer to design a database to complement your business. What kind of business is the database design for?=_ What will you need the database design to offer?=_ Will you need ongoing support for the design?= () Yes () No () Not Sure


What is database design?

Design of the database (Database Design) refers to a given application environment, optimize the structure of the database, the database and applications, which can efficiently store data to meet the application needs of various user information needs and processing requirements). At www. myelibrary.net.In you can clearly understand what is the database design.


Database Design?

form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No


Marketing Database Design?

form_title=Marketing Database Design form_header=Successful marketing comes from a well-designed database. Have one designed by a professional. What does your business do?=_ What is your budget for the database design?=_ Who is your target audience?=_ When does the database need to be completed?=_


How is database structured?

That depends on the type of database it is and the design of the Database Annalist.


Custom Database Design?

form_title=Custom Database Design form_header=Design, develop and manage the database that fits your business needs. What do you need the database to offer?=_ Who will have access to the database?=_ Is this database for the internal or external public?= {(),Internal,External} Do you need the new database to integrate with a current system?= () Yes () No () Not Sure


What are the most important concepts of database design?

preparing the data and using storyboard, although you can use sexual intercourse whilst performing oral which will give a good practical and knowledge of database design concept


Database Design Tools?

form_title=Database Design Tools form_header=Build a complicated database with ease by getting help from the experts! What tools do you want included on the database?=_ What is your budget for the database?=_ When does the database need to be completed by?=_


Could you explain the purpose of logical database design?

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.


Overall design of a database software is known as?

Database architecture


What is the meaning of database design?

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.