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
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!
Designers design the original database. That is an extensiveprocess, including working out the structures, doing up specialdiagrams, choosing the correct software and computer…s to use andother things. Finally the database will be created. The job of theadministrator is to look after the database. The administratorlooks after things like security, backups, providing services tothe users, updating data and maintaining the database. Thedesigner's role is mainly before the database comes into use andthe administrator looks after the database when it does come intouse.
Engineer requirements should be higher, on theapplication of large databases to achieve proficiency orproficiency level, so the relatively low level of developmentengineers da…tabase, the cost is lower. Data architects, generalbusiness needs one or two. Of employment database developmentengineer is the most extensive. Here are some cases for referenceonly. (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 isstored in the database. If a database is unwieldy and disorganized,troubleshooting can become impossible.
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 haveother roles like being an analyst or a database administrator.Whoever is designing a database may work with peop…le in some ofthose other jobs, particularly when it is a very large system. Ifit is a small database, then it is easy to design and somebody witha bit of knowledge of databases can design and create one.
There is only one meaning of the words database design. Data basedesign means the process of creating a very detailed data model ofa database. It is used for a database, of co…urse. Hello, Database design is part of system development, it is the process ofproducing a detailed data model of a database. A database is acollection of information that is organized so that it can easilybe accessed, managed, and updated. Databases are used everywhere inthe world of web development. - conceptual database design - logical database design - physical database design Database designing , website designing & development requiresproper knowledge about that. If anyone wants more information aboutthat can communicate with the Hvantage Technology. I also visitedthis 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 specializesin databases. Therein they will investigate the requirements of theend user platform, design the system inte…rface to create, edit andreport on stored data , design user interfaces, design reports,structure and develop an optimized platform.