What would you like to do?
The answer (1 issue)
- Contains user information or spam
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.
5 people found this useful
Was this answer useful?
Thanks for the feedback!
Database Design is the database structure that will be used as plan to store and manage data. The database management system (DBMS) is the software used to implement a databas…e design. Modern database and applications development software is so easy to use that many people can quickly learn to implement a simple database and develop simple applications within a week or so, without giving design much thought. As data and reporting requirements become more complex, those same people will simply (and quickly!) produce the required data by incorrectly adding more columns of tables to the database. That's how data redundancies and all their attendant anomalies develop, thus reducing the "database" and its applications to a status worse than useless. The following are basically the reasons for doing database design: • Good application programs can't overcome bad database designs. • The existence of a DBMS does not guarantee good data management, nor does it ensure that the database will be able to generate correct and timely information. • Ultimately, the end user and the designer decide what data will be stored in the database.
Well, there are actually FIVE (or even SIX, according to some..) but the first three are the most commonly cited parts of normalization.\n \n1) Identification of data and grou…ping in to logical units (e.g. fields and tables)\n \n2) Establishing key values for each table\n \n3) Analyzing relationships and eliminating non-key dependencies\n \n. \nA database that is in "Third Normal Form" is usually pretty correct, logically speaking.
Please refer to the link given http://www.databasedev.co.uk/design_basics.html
DBMS is Database management system .Database design is very important in DBMS, It serves as a foundation of DBMS.
hmm, I start to think what am will doing with database, usually I write firts all my idea on a paper and when it ready to build, I use my database application.
A database designer is a person who specifies how a database records are stored, accessed and related to make sure there is adequate performance!
Engineer requirements should be higher, on the application of large databases to achieve proficiency or proficiency level, so the relatively low level of development eng…ineers database, the cost is lower. Data architects, general business needs one or two. Of employment database development engineer is the most extensive. Here are some cases for reference only. (Www.myelibrary.net)
I shall give you a solution to what i think it is, if i am wrong, post back with further queries. First of all what tables you need depend entirley on what information your co…mpany is interested in retaining. I will assume all and you can delete as nesseccary First of all there should be a person and a product table: PERSON (person_ID*, name, start_date, end_date) PRODUCT (product_ID*, name, description, price, colour, weight, size, stock, start_date, end_date) //add more fields as nesseccary if you want to keep track of your staff make a staff person table: STAFF_PERSON (sp_ID*, staff_ID, person_ID, start_date, end_date) //assuming a staff table exists already Then you are going to want a customer table: CUSTOMER (customer_ID*, person_ID, name, start_date) Then tables to connect customer to person and customer to product: CUSTOMER_PERSON (cp_ID*, customer_ID, person_ID, start_date, end_date) //this is to keep track of your customers names and other details that might be in the person table PRODUCT_CUSTOMER (pc_ID*, customer_ID, product_ID, staff_ID, start_date, end_date) //this is to keep track of which products have been sold to which customers. (I put the staff_id in this in case you need to know who sold it for commision) This is only a very simple solution, but I think it will give you the gist of what needs to be done. If you need more help with, or I didnt answer your question then just repost here and i wil get back to you.
The responsibilities of the DBA and the database designers is to prevent conflict of data between different departments and to ensure the security of the data.
All of the information and data that is pulled to make websites is stored in the database. If a database is unwieldy and disorganized, troubleshooting can become impossibl…e.
The first and most important step in designing a database is creating a schema. After creating schema tables are created and data is entered in to the tables.
A fan trap is where one too many relationships 'fan' out from a central entity, so the link between the two entities at the many end becomes unclear. For example, if we had a …central entity of Branch (of an organization) and two entities fanning out from it: Staff and Department, we cannot clearly link Staff with Department.
A database or systems designer will do it. They could also have other roles like being an analyst or a database administrator. Whoever is designing a database may work wit…h people in some of those other jobs, particularly when it is a very large system. If it is a small database, then it is easy to design and somebody with a bit of knowledge of databases can design and create one.
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 good database design requires that the Data is conveniently and efficiently stored. Also the data can be easily stored and maintained.
Database designers are a type of software engineer that specializes in databases. Therein they will investigate the requirements of the end user platform, design the syste…m interface to create, edit and report on stored data , design user interfaces, design reports, structure and develop an optimized platform.