answersLogoWhite

0

📱

Database Programming

Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.

8,803 Questions

How to turn the tables in a narcissist relationship?

Unfortunately, narcissism is a life long disease. If your partner is clinically narcissistic, there is very little hope of him or her ever changing.

How do you type the restricted symbol?

**Note: The symbol that you are using for restricted is not the restricted symbol or special character. In fact it is the Registered symbol and that symbol or character can be typed:

If using a Microsoft Windows System you will press and hold Alt then press 0174 ®. But if you can't remember this you can always just open up the Character Map Program that is usually found in the Accessories section of the Start Menu or can be searched using your Help on your computer.

If using a Apple Macintosh System you will press and hold Option and then R. Which will then show the ® character. (Note: that you do not press the Shift key otherwise you will insert a ‰ symbol.) But just like the PC Mac's come with a Character Map feature as well, but also has one better called the Keyboard Viewer. And that is a virtual onscreen version that you can see which key is what character by holding down the Option key and/or any of the other Modifier keys (Shift, Ctrl, Option/Alt, and Command/Apple) on the keyboard.

Hope that is less confusing then the original Answer up top.

What is a 'normalform' in a database?

Normal form (NF) is a state desired by database admins. It exhibits proofs that the designed system files or tables do not contain any duplicated fields. To achieve the desired NF, designers need to assess the dependencies of fields (info) in relation to others. This is done trough Normalisation process, starting from 3rd normal form down to 2nd normal form. Normal form (ie. 1st NF) is reached when fields are no longer duplicated and optimally selected as table unique keys.

What is the prefix of query?

query is term generaly means to find something which if a person wants

How do you convert RAW data type into TEXT?

For example 50 is just raw data. 50 degree is text ,so raw data with some context becomes a meaningful text.

What restrictions does referential integrity place on the way data is entered into table?

Once the tables are created and the relationship is established, the data can be entered. In general, data can be placed in tables containing foreign keys only after the data is entered into the tables that they reference. This restriction means that data must be inserted first into the MEMBER table. If not, the data for the VISIT table will be rejected for the referential integrity violations.

How do you join the stajettes?

How do you join the stajettes? i dont kno how i jus wanna be aprt of them becuz i think dey dance good nd i think im good fro da group cuz i kno how 2 dance and all da stajettes is my age

Difference between data structures and ADT?

Abstract Data Types:

ADT is a mathematically specified entity that defines a set of its instances, with:

  • a specific interface - a collection of signatures of methods that can be invoked on an instance,
  • a set of axioms that define the semantics of the methods (i.e., what the methods do to instances of the ADT, but not how)

Abstract Data Types (Examples):

  • Lists, Trees
  • Stacks, Queues
  • Priority Queue, Union-Find
  • Dictionary

Data Structure

In a general sense, any data representation is a data structure.

Example: An integer

More typically, a data structure is meant to be an organization for a collection of data items.

From: Shoaib Sidhu

How to view whats on your hard drive?

Click on My Computer. It is usually a screen icon. In Microsoft Windows click the Microsoft 'start' icon, which looks like a flag at the bottom left of your screen. This will open a menu. Click on the word 'Computer'.

This will then display all your drives. Click on 'C' drive (The 'C drive' is normally the designation given by the system to your hard drive) and it will list all the folders, which you can click on to see sub-folders and files.

Where does global static local register variables free memory and C Program instructions get stored?

* These are all implementation defined. Access to `register' specified indentifiers should be as fast as possible, so the compiler may place the value in a machine register. However, the compiler is free to treat a `register' declaration as an `auto' declaration. * Where free memory is maintained is an OS specific concept. Instructions are generally stored in code segement. Local Variables are stored in Stack. Register variables are stored in Register. Global & static variables are stored in data segment. The memory created dynamically are stored in Heap And the C program instructions get stored in code segment.

What are Field Types in Access?

Data types.

Field types in Access (The absolute lowlevel Database engine, just above text files) include:

Text

Number

Yes / No

These fields all have charistica that decide length, decimal spaces, default values and such. Using the correct field types for data, and not just text for it all, will result in faster computing and easier coding.

What is a chart wizard?

A feature on EXCEL that provides a series of dialogue boxes that help create or modify a chart.

Where is RDBMS used?

firstly what is database, a collection of information in called data and collection of data is known as database. data stores in the form of tabels and in the RDBMS two or more tables hold a relation. they allow fragmentation of the data(fragment of rows or columns for tables). RDBMS consists 14 cord's rules for RDBMS, there are no any RDBMS which are follow the cord's rules. RDBMS is used in Banking system,Airline ,Railway reservation sytem or where we take information from two or more tables.

the distributed form of database must be RDBMS.

Sohrab Hamid Siddiqui(CMC, noida, india)

What are the different ethical views on lying?

One particular ethical view on lying is with respect to whether or not the intended outcome serves a good or evil purpose. If lying is done to unfairly cheat or deceive someone for selfish reasons, then it is bad/wrong. If however lying is done to serve the greater good of someone or a society as a necessary evil to shield them from harm and torment, then it is good/righteous.

What are the advantages of using a linear model for a set of data?

I just did this for homework, advantages include creating a graph for not constant date like opinions such as black cats V.S white cats in your class, or a classroom based experiment, how many pennies a paper bridge of certain length can hold, different answers every time. ANSWERS WILL VARY for opinion based or experiment based data. Things that will graph at a constant rate is statistics or mathematical number sequences.

Er diagram on company employee database management system?

an ER diagram on company employee database management systems can be viewed by visiting the following website: elearning.vtu.ac.in/17/e-Notes/10CS54/Unit2-KRA.pdf. This is a PDF document that shows the diagram.

What are the properties of data types?

When we enter a variable then we know it what type it belong ,but the compiler does not know it ,for knowing it we declare data types. Storage representations & machine instructions to handle constants differ from machine to machine.The variety of data types available allow the programmer to select the type appropriate to the needs of the application as well as the machine.

ANSI C supports 3 types of data types

1.Primary data types

2.Derived data types

3.User defined data types

JAVA has 2 types

1.In Built data types

2.User Defined datatypes

Mapping in DBMS architecture?

We know that three view-levels are described by means of three schemas. These schemas are stored in the data dictionary. In DBMS, each user

refers only to its own external schema. Hence, the DBMS

must transform a request on. a specified external schema into a request against conceptual schema, and then into a request against internal schema to store and retrieve data

to and from the database.

The process to convert a request (from external level) and the result between view levels is called mapping. The mapping defines the correspondence between three view levels. The mapping description is also stored in data dictionary. The DBMS is responsible for mapping between these three types of schemas. There are two types of mapping.

(i) External-Conceptual mapping (ii) Conceptual-Internal mapping

External-Conceptual Mapping

An external-conceptual mapping defines the correspondence between a particular external view and the conceptual view. The external-conceptual mapping tells the DBMS which objects on the conceptual level correspond to the objects requested on a particular user's external view. If changes are made to either an external view or conceptual view, then mapping must be changed accordingly.

Conceptual-Internal Mapping

The conceptual-internal mapping defines the correspondence between the conceptual view and the internal view, i.e. database stored on the physical storage device. It describes how conceptual records are stored and retrieved to and from the storage device. This means that conceptual-internal mapping tells the DBMS that how the conceptual! records are physically represented. If the structure of the stored database is changed, then the mapping must be changed accordingly. It is the responsibility of DBA to manage such changes.

If a large table contains thousands of records and the application is accessing half of the table which method do you use index searching or full table scan?

Generally, if a select is accessing half of a table it will do a table scan. With thousands of records that should not slow it down much. If you were talking millions of records that might be a different story.