0
Database Design
Database design is the process of creating a detailed data model of a database. It is the next step after requirement gathering and before coding begins. A good database design can save a lot of time during the database development.
1,295 Questions
What are anomalies in DBMS and their types?
Tables that have redundant data have problems known as anomalies.So data redundancy is a cause of an anomaly.
Redundancy is the duplicaion of the data.
There are 3 types of anomalies.
Insert Anomaly:When you insert a record without having it stored on the related record.
Delete Anomaly:When you delete some information and lose valuable related information at the same time.
Update Anomaly: Any change made to your data will require you to scan all records to make the changes multiple time.
Activity diagram for video rental system?
i knew how to draw the activity diagram fro video rental system but i dont know how to attach it here
How can made the dfd of sales management system?
through the orignal watch the / visit the system of 2 or 3 organization the the the best ICS(internal control system is best) then draw it
Explain the advantages and disadvantages of weapons introduced in modern world?
advantags are,, ppl will scare if u have the most distructive weapon , they wont simplay just go to war with u >> so that good!!!! the other hand is ppl will try to invent more distructive weap-on to overtake u .. if ther is a war really ahppen they.. will be all dead!!!!!
Entity relationship diagram for online banking?
An entity-relationship diagram for online banking includes the process of online banking and the relationship between each step. It is a model that maps out, describes, and defines how components are linked for online banking.
Er diagram for online shopping?
probably, online shopping is not advisable because you can only see it trough internet but you can't touch the texture, quality and smoothness so maybe, it is not what you like when you see it.
What are the attributes of good information?
Currency - is the information up to date? Accuracy - accurate for its use - i.e. daily production figures, weekly sales figures, monthly overall figures, yearly production figures rounded up to nearest £'000 Relevance - how relevant it is to the end user - i.e. a machine breaks down 4 times in one day - who needs to know this - the operations director - no - the quality assurance supervisor - yes. Completeness - incomplete information has an affect on the decision making process of the end user Cost effectiveness - how much does it cost to collate the information - is this feasible? Is it a tanglible cost - can it be quantified - savings on Work In Progress? Is it intangible - i.e. customer satisfaction
What is a logical database designer?
* 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 designer
The 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.
orakridge relational automatic computer logical engine orakridge relational automatic computer logical engine
What are database relationships?
The question is too vague for a sound answer so I will try to shotgun it.
The most basic relationship is a parent-child relationship. The parent table might be "Department," the child table, "Employee." The child can not exist without a parent. Bob and Jill may be children in the Shoe department. Mary is the child in the Canoe department. The Glue department has no children; Harry was the only employee but they had to let him go over a sticky situation.
As you can see, a parent might have many children, one child, or no children.
Quantity relationships are the next type of relationship the question may be asking about. Quantity relationships do not have to be between parent and child tables.
As you can see, Departments can have many children. That is known as a one-to-many relationship. One department, many employees.
A many-to-one relationship might be a customer with multiple addresses, say mailing, billing, and shipping.
Employee and Employee Number tables might represent one-to-one relationships. Rather than use Mary Boudreaux every place you need to identify her, you assign her an employee number. Mary is in the Canoe department. Her number is C75. C for Canoe, 75 for the 75th employee of the company.
Finally, there is the many-to-many relationship. All the employees work for commission. There is a sales table with many entries. Each entry is related to one of the many employees in the employee table.
There are symbols for each X-to-Y relationship.
The question might also refer to "Key" relationships. Primary Keys (PK) and Foreign Keys (FK) are used mostly between tables. A full explanation of the PK/FK relationship usually results in glazed eyes and confusion without visuals.
How does hibernate work with multiple databases?
With out databases you wouldn't have any were to store information!
How is a relational database system different from other databases in tabular form?
To put it simply there are many types of data systems. But we'll just talk about two of the most common here: The first is commonly known as flatfile. The flat file is pretty simple: Each major category of data (e.g. Employees) is contained in a single file. If that employee can have multiple phone numbers, the flat file has to be set up with space for each possible number (home, work, cell, pager, etc). (Unlike what the original answer said) you can set up basic links between flat files (e.g. on an employee id), but flatfile databases are not set up for working with multiple files at once.
What is the advantage of denormalization over normalization?
If you meant disadvantage of normalization then these are the answer for your query.
More tables to join: By spreading out your data into more tables, you increase the need to join tables. Tables contain codes instead of real data: Repeated data is stored as codes rather than meaningful data. Therefore, there is always a need to go to the lookup table for the value. Data model is difficult to query against: The data model is optimized for applications, not for ad hoc querying.
Difference between traditional and latest DBMS package?
Traditional FPS and DBMS both are different from each other. In DBMS there is security of data as well as integrated data while this is not in FPS.
There is need of database in each and every field. The database is need to store data in a systematic and efficient manner.
What are the benefits of a hierarchical data model and network data model?
In network model of database , all data is related to each other through a link. By a link we mean that it is an association between precisely two records/data . In hierarchical model records are organized as trees rather than arbitrary graphs.
What is a type check on a database?
Checking that data types are correct for what they are needed for. If data types don't match or are of the wrong type, it can cause problems. Dates should not be stored as text for example.
List the steps to print a test page in Windows?
Open Devices and Printers by clicking the Start button , and then, on the Start menu, clicking Devices and Printers.
Right-click a printer, and then click Printer properties.
On the General tab, click Print Test Page.
Why are databases used globally?
Computers are data processors. We talk about the computer industry as being Information Technology. Data and information are key to computing. A database is an application designed to manage data and give us information. All around the world we need data, so naturally databases are used all around the world.
