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 does a computer have to do with math?

A computer has to do with Mathematics, because on a Macintosh, you can download Sketch-Up, for example. Here, you can build your own 3D buildings, etc. This has to do with geometry.

Another example is using a tablet to write down mathematical notes on Pixelmator, another application on the Macintosh.

What can't a switchboard in access do?

Well, honey, a switchboard in access can't make you a cup of coffee or give you a foot massage. It also can't magically fix all your database problems or make your boss disappear. But hey, at least it can help you connect and manage your phone calls like a pro.

How much does it cost to create a database project?

The cost of developing a database project is dependent on such factors as the complexity of the project, the size of the database, the type of technology involved, and the expertise of the developers. The small to medium-sized database project costs will usually range from $2,000 to $10,000, whereas the large to medium-sized complicated projects might range between $10,000 to $50,000 or more. Further costs may include database maintenance and security of the data. To get the precise pricing you can require a quote in detail from your developer on your specific requirements for the project.

To know more..connectinfosoft

Which database is closest to the user?

The client-side database is that which is closest to the user in terms of physical proximity and interaction.

Client-side databases are those databases maintained at the device level of the user, such as a web browser, mobile device, or desktop application. These databases are directly accessible by the user's device and, as such, do not require any network connection to interact with whatever data is stored within.

The most common examples of client-side databases will be as follows:

Web browser storage: This constitutes a set of technologies like Web Storage-component localStorage and sessionStorage-and IndexedDB, which allow web applications to locally store data in the user's web browser. Most often, mobile applications make use of local databases like SQLite to store data on the user's device for offline access and improved performance.

Desktop application databases: Besides those above, desktop applications could be able to utilize embedded local databases like SQLite or some other database engines to locally store user-specific information. Benefits The advantages of client-side databases are the speed at which data is accessed, plus it is fully online; hence, a user's dependency on network connectivity is reduced. Limitations Data capacity, security, and synchronization limitations across multiple devices are serious shortcomings of this solution.

In contrast, server-side databases sit on remote servers and are accessed via network connections. Database systems designed for servers store and manage massive volumes of data for multiple users and applications. Examples of server-side databases include MySQL, PostgreSQL, MongoDB, and many others.

While server-side databases are crucial in holding and managing vast data sets, client-side databases present users with direct and speedier response interaction on their own devices with the data.

To know more..connectinfosoft

What is a general purpose software?

A software is something that serves for a specific purpose. Software can be of two types Specific or general purpose. A general purpose software is one which is developed for people not for any particular firm. Example of general purpose software are adobe flash, microsoft word, microsoft office etc.

What reasons are their for normalising data?

To remove multi-valued fields/remove repeating group

To establish the entities

To establish which attributes belong in each entity

To establish relationships between entities

To avoid update/deletion/insertion anomalies (Max 1 mark)

To overcome the limitations of flat files (including prevent data

duplication/data inconsistency errors)

Identify both primary and foreign keys (1 mark needs both primary and foreign)

What is a database cell?

A database cell is a single piece of data stored at the intersection of a row and a column in a database table. It represents the smallest unit of information that can be stored in a database. Each database cell typically contains a specific data value, such as a number, text, date, or other data type.

What are true of a cellular topology?

- It consists of a number of hubs that form geographical cells for connections.

- It uses point-to-point and multipoint connections.

- Users and devices can roam from cell to cell in the network.

WHAT IS Tiny Blob?

A binary field that can store "files" of up to 255 bytes in length.

What is difference between natural join equijoin and outer join?

Equijoin - Joins two or more tables where the specified columns are equal. Returns only those records found in both tables.

Outer join - Joins two or more tables on the specified columns, returning all the values from table 1 regardless of whether they are in table 2.

Natural Join - Joins two tables on all like column names.

What is the difference between cartisean product and natural join operation?

A Cartesian join is when you join every row of one table to every row of another table. While on occassion this may be needed I would argue that a properly constructred database would negate this. This is in fact a VERY hard hitting operation on your resources and should be avoided at any cost. A normal join will include the comparison of one or two fields between tables. While you want to limit the number of joins you have in a query a properly constructed join is not a big use on resources. This of course takes into consideration proper indexing and database construct.

Does the size of a rubber band effect how far it will fly?

Yes, the size of a rubber band can affect how far it will fly. Larger rubber bands typically have more elasticity and can store more energy when stretched, resulting in a longer flight distance compared to smaller rubber bands which may not have as much elasticity. However, other factors such as the force applied when releasing the rubber band and the aerodynamics of the object being launched also play a role in determining the flight distance.

What are the Building blocks of a database?

Every database should contains values/datas represented in records(rows) and fields(columns). And records and fields stored in a table. So the main building blocks of a database is Table.

What does the name Noe mean?

The name Noe is of Spanish, Portuguese, and French origin, derived from the Latin name Noah, meaning "rest" or "comfort." It is also a variation of the biblical name Noah, which means "to comfort" or "to rest."

As water is cooled what happens to the density?

As water is cooled, its density increases until it reaches its maximum density at 4 degrees Celsius. Below 4 degrees Celsius, water begins to expand as it freezes, which is why ice is less dense than liquid water.

What is a field called in a physical database?

In a physical database, a field is also called a column. It represents a specific piece of data that is stored in a database table, such as a name, age, or address. Each column typically has a data type that defines the kind of data it can hold.

How can you determine the curvature and Refractive Index of spectacle glass?

The curvature of spectacle glass can be determined using a lensometer, which measures the curvature of the lens surface. The refractive index of spectacle glass can be determined by analyzing the way light passes through the lens and using equations that relate angles of light refraction to the refractive index of the material.

What is the full form of FASTA?

FASTA stands for "Fast Alignment Search Tool". It is a software package used for searching nucleotide or protein databases with a query sequence.

What is the importance of database design in DBMS?

A query is how you extract information from a database, which is one of the main reasons we have databases. There are other kinds of queries, such as ones to add, edit and delete data and manipulate data in other ways and do other things with tables, but the ones that extract information are the most used.

Block diagram of microwave communication link?

A microwave communication link typically consists of a transmitter, a receiver, and an antenna at both ends. The transmitter converts the electrical signal into microwave signals, which are then transmitted through the antenna. The receiver at the other end captures these microwave signals through its antenna and converts them back into electrical signals for further processing. The link may also include devices such as amplifiers, filters, and antennas to enhance signal quality and transmission.

Molecular arrangement of solid liquid gas and plasma?

In a solid, molecules are tightly packed together in a fixed lattice structure. In a liquid, molecules are more loosely packed and can move past each other. In a gas, molecules are far apart from each other and move freely. In a plasma, atoms are stripped of their electrons, resulting in a highly charged state where particles move rapidly and are electrically conductive.

What happens to the density of a cooled liquid?

It will tend to increase, but this is not the case for all liquids.

The reason this happens is because as the liquid's molecules gain energy they exert force on their neighbouring molecules, which leads to the molecules becoming spread apart as the temperature increases. Conversely, when the molecules get colder and lose energy they exert less force on neighbouring molecules and so they get closer and the density increases.

However, in water this trend is true for all temperatures above 4oC, but not below 4oC. When water goes below 4oC the density starts to decrease. This is due the the oxygen being very electronegative, giving the water molecules a slight charge bias (the cause of effects like water tension) which makes them like little bar magnets. As the temperature drops the molecules become less able to overcome this slight charge bias, which pulls the water molecules into a shape like that of ice (which we know has a lower density than liquid water.

What is collation character set applicability table?

A collation character set applicability table is used to determine which character sets can be used with a specific collation in a database. It specifies which character sets are compatible with a particular collation for sorting and comparison purposes. This table helps ensure that the data is stored and retrieved correctly based on the collation rules.

What are the entity integrity and referential integrity constraints Why is each considered important?

Entity integrity ensures that each row in a table is uniquely identified by its primary key, preventing duplicate or null values in the key column. Referential integrity ensures that relationships between tables are maintained by enforcing foreign key constraints, preventing orphaned or invalid references between tables. Both constraints are important to maintain data accuracy, consistency, and reliability within a database system.