answersLogoWhite

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 is media scares?

Media scares are curpose that it gives you a chance.

Why companies use database?

to store its information so that it will be easily accessed

What is the advantages of object oriented data model?

Object oriented means the internal structures used in an application represent the real world 'objects'. This means the application you are creating is using a model that is closer to the real world and that is always an advantage. The biggest advantage may be in the form of easy maintenance as the application evolves.

What is the basic purpose of 4NF?

The purpose of 4NF, or the 4th Normal Form, is to remove multivalued dependencies. This means that by adding a new value to the database, multiple other values are not required to maintain consistency.

How is a database different from a database management system?

A database is simply the data that has been stored in tables. A database management system includes all the elements that are required to work with the database. This would include things like the language to write queries, facilities for creating reports, controls over security and access of data and other elements.

Features of traditional database?

the traditional database do not follow these rulesDr. E. F. Codd's 12 rulesfor defining a fully relational database

Note that based on these rules there is no fully relational database management system available today. In particular, rules 6, 9, 10, 11 and 12 are difficult to satisfy.

  1. Foundation Rule

    A relational database management system must manage its stored data using only its relational capabilities.

  2. Information Rule

    All information in the database should be represented in one and only one way - as values in a table.

  3. Guaranteed Access Rule

    Each and every datum (atomic value) is guaranteed to be logically accessible by resorting to a combination of table name, primary key value and column name.

  4. Systematic Treatment of Null Values

    Null values (distinct from empty character string or a string of blank characters and distinct from zero or any other number) are supported in the fully relational DBMS for representing missing information in a systematic way, independent of data type.

  5. Dynamic On-line Catalog Based on the Relational Model

    The database description is represented at the logical level in the same way as ordinary data, so authorized users can apply the same relational language to its interrogation as they apply to regular data.

  6. Comprehensive Data Sublanguage Rule

    A relational system may support several languages and various modes of terminal use. However, there must be at least one language whose statements are expressible, per some well-defined syntax, as character strings and whose ability to support all of the following is comprehensible:

    1. data definition
    2. view definition
    3. data manipulation (interactive and by program)
    4. integrity constraints
    5. authorization
    6. transaction boundaries (begin, commit, and rollback).
  7. View Updating Rule

    All views that are theoretically updateable are also updateable by the system.

  8. High-level Insert, Update, and Delete

    The capability of handling a base relation or a derived relation as a single operand applies nor only to the retrieval of data but also to the insertion, update, and deletion of data.

  9. Physical Data Independence

    Application programs and terminal activities remain logically unimpaired whenever any changes are made in either storage representation or access methods.

  10. Logical Data Independence

    Application programs and terminal activities remain logically unimpaired when information preserving changes of any kind that theoretically permit unimpairment are made to the base tables.

  11. Integrity Independence

    Integrity constraints specific to a particular relational database must be definable in the relational data sublanguage and storable in the catalog, not in the application programs.

  12. Distribution Independence

    The data manipulation sublanguage of a relational DBMS must enable application programs and terminal activities to remain logically unimpaired whether and whenever data are physically centralized or distributed.

  13. Nonsubversion Rule

    If a relational system has or supports a low-level (single-record-at-a-time) language, that low-level language cannot be used to subvert or bypass the integrity rules or constraints expressed in the higher-level (multiple-records-at-a-time) relational language.

What is loanIQ?

check http://en.wikipedia.org/wiki/Misys Misys Loan IQ: A front-to-back commercial loan processing solution that covers the entire life cycle of a loan - from origination and deal tracking to accounting and settlement. It can be used to process simple bilateral deals to highly complex syndicated deals, including secondary trading. Loan IQ transforms the complexities within the loan cycle into a streamlined, controlled process, and provides the client with full visibility into the loan life cycle. As a result, clients can better manage their loans, streamline work flow, increase efficiencies and reduce operational risk. Loan IQ is used by over 60% of the North American and European agent banks, and processes more than one third of the world's syndicated loans and half the global traded loan volume. Now as part of LOAN IQ product suite there are subsystems like Misys Loan Cordinator , Trader's Desktop and a Reporting framework called Datanet too, which gives users a good experience in Syndicated Lending work flow automation.

How do you put a head on someone elses body in a photo?

There are three ways to do this. It all depends on your equipment. You're probably using Photoshop, and if I was asked to do this again (I've put LOTS of heads on other bodies), I would make a PSD with three layers. Two layers are copies of the "body" photo, the third is the "head." Sandwich the head between the two body layers, and do a lot of masking and feathering. If I was going to do it as a handcut collage, I'd use an X-acto knife to cut out the head, wax it with a hand waxer (glue sticks work too) and carefully stick it in place. Then take another photo of it. Another way requires amberlith...you use it to make masks, photograph the head and body images through masks and strip the two together.

Information technology act 2000?

The following are its main objectives of I T Act 2000

1. It is objective of I.T. Act 2000 to give legal recognition to any transaction which is done by electronic way or use of internet.

2. To give legal recognition to digital signature for accepting any agreement via computer.

3. To provide facility of filling document online relating to school admission or registration in employment exchange.

4. According to I.T. Act 2000, any company can store their data in electronic storage.

5. To stop computer crime and protect privacy of internet users.

6. To give legal recognition for keeping books of accounts by bankers and other companies in electronic form.

7. To make more power to IPO, RBI and Indian Evidence act for restricting electronic crime.

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.

Informatics practices project for class 12?

Websites designing, educational websites.

from Adesh Paul

What does the term field mean in relation to databases?

The field is where data is entered. For example, a phone book database may have fields such as LName, FName, Add1, Add2, City, ST, ZIP, AC, Phone. Also, for the phone company's version of said database, they may have some additional fields such as Unlisted, NoAddr (as not everyone wants their addresses in the phone book), FInit (since some want only their first initials rather than their names in the phone book), etc. Fields can be of various types, of course, such as numeric, string/text, boolean, time/date, and more. What data types are allowed depend on what type of database software you are using or whether you are custom designing your own software by programming in C, Pascal, or another such language.

What factors influence the selection of screen ruling and dot percent?

The factors are the printing methods that are be going to be used, eg:Sheet fed:CMYK Process, Standard round dot. Flexography: stochastic Screen

Can you download and record movies using real player from hulu.com?

No. The movies are streaming from the net. Therefore; all you will be able to download is the intro of the network's logo.

No, real player can not download and record movies from Hulu.com, If you want to download video from Hulu, you can use one of several video capture programs which will allow streaming video to be stored as a file.

Real player 11 is now support to download video on site, if you upgrade to it then you may try it.

But a one stop solution will be a streaming video recorder. Search it in Google and find one can help you download movies at good video quality.

What are the disadvantages of normalisation?

When we use Normalisation it does not allow some of the modifications of the database. Another disadvantage of Normalisation is that it is only applicable in the Relational Database Management System.

How much storage do you need for a multi-media website?

It depends on how you deploy your site. It is recommended that video and image files be stored outside of your database. That said this is more a question of how much hard drive space you need. Your database size will be influenced by how the database is built, the functionality of the application which speaks to how much detail is maintained in the database, and how many records (number of customers as an example) you will have. There will also be credit card transactions that need to be maintained in a database for years, pointers to your content which should be database driven, and other factors. In short it is not possible to blindly answer this question with any level of accuracy.

What is prototyping and why is it important?

A prototype is basically a mock-up. In the database world you can use software to simulate a situation or even build a mock-up database. A Mock-up database will be a 'simple' version of the intended end product. It will not have all of the tables that the finished product would have, or all of the fields in the tables it does have. An example might be a billing engine that you are building. If you are going to embed busines logic into the database you might put together a functional mock-up of a certain core component of this system, say the tables that contain computed interest and Billing rule logic. From there you might write stored procedures that are to computer these values; and run it to verify the results. This is important because if you have some ideas or thoughts on how to handle a given situation you can produce a mock-up of a couple implementation strategies and test these for best result. If you simply build out your entire database and application without testing some of your concepts you will often find yourself with a completed project that is less than optimal in functionality, scale, and performance. Always consider your implementation options and test each (or your top two or three methods) to determine your best of breed approach. You may know in your head what will work best but you would be surprised at the results when tested; at times.

************************************or************************* Evolutionary prototyping is the process of developing the final software system by enhancing the prototype-that is, the prototype evolves into the final product.

What is the goal of a database designer?

A database designer in simple terms designs the database layer of the eventual application. Like the initial crew on a home build site the database designer (architect) is responsible for laying the foundation of the project. The architectural structure and integrity of the database is one of the most important key elements to insuring a solid application build. While the application layer can be re-worked easily the database layer can not. Many attempt changing and molding the database to fit a 'floating' or changing requirements vision however this always turns into a mess. Without a proper FOUNDATION (the database in this case) the application will ultimately fail to meet the performance and or functional requirements of the project and often will cause the entire project to fail. In closing; the GOAL of the database architect is to construct a database environment that maintains its data elements reliably, provide a high performance architecture that will scale with the business model, provide a construct in which data integrity is maintained, and employ best practices to insure a stable and secure environment.

What does 'Advantages of proposition' mean?

in business advantage could include factors like a broad range of product selection , superior customer services, highest quality & best price and so on...

How do you prioritize IP address?

There is no inherent priority in Internet Protocol Addresses.

Therefore, you don't prioritize them.