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 the main ways users can access information stored in DBMS?
Users can access information stored in a database management system (DBMS) through querying the database using SQL commands, utilizing graphical user interfaces (GUIs) provided by the DBMS software, and interacting with applications that have been developed to retrieve specific data from the database. Additionally, users can access information through custom-built APIs or web services that connect to the DBMS.
Which is NOT a commonly used database application?
Borland Paradox, it was popular on PCs for several years but was discontinued in the 1990s.
What is the name given for incorrect data?
Often it's simply referred to as invalid data or even garbage data. If it's data that was once valid but is now invalid or unrelated to other data, it might be referred to as orphaned data or an anomaly.
What are the disadvantages of a paper-based data base?
Some disadvantages of a paper-based database include limited storage capacity, difficulty in organizing and searching for information, and vulnerability to physical damage or loss. Additionally, paper-based databases are less efficient in terms of retrieval and sharing of data compared to digital databases.
'def' is a reserved word used internally by the Ruby language to define a method. The definition terminates with 'End'.
That is the Greek letter Epsilon which indicates summation.
What is the subset mapping in DBMS?
Subset mapping in DBMS refers to the process of mapping one subset of data from one database to another subset of data in another database. This is typically done to synchronize or transfer data between databases while ensuring that only relevant subsets are affected. It helps in maintaining data consistency and integrity between databases.
An Is a database object used to enter data into a database table?
A form is a database object used to enter, modify, and view data within a database table. It provides a user-friendly interface for users to input data without directly interacting with the underlying table structure. Forms can include various controls like text boxes, drop-down lists, and buttons to enhance the data entry process and improve user experience.
Why choosing the correct field in database is important?
Choosing the correct field in database is very important. It is because the correct field can give you the correct value.
Was the whodunit game a database?
No, the whodunit game is not a database. It is a type of mystery game where players try to solve a crime by identifying the perpetrator, the weapon used, and the location of the crime based on clues provided. The game usually involves deductive reasoning and critical thinking skills.
How do you write a Fibonacci number sequence as a function in assembly language?
The process requires an understanding of the problem, understanding the tool, then the implementation in edit/test cycles.
For example, you would want to understand the task first. Are you required to "write a Fibonacci number sequence" as a series of Fibonacci numbers in a range from A to B (e.g. 0, 1, 1, 2, 3, 5, 8), or are you required to create a tool that can create fib(N) for any argument N? What are the value constraints for N? Is the implementation of fib() required to support any number of N, including very large numbers or even infinity?
The next step would be the selection of a suitable tool and algorithm. For example, one would want to use an assembly language based on its theoretically superior processing speed. (One might want to chose a higher-level programming language, for example in order to support portability of code to other processors.)
The selection of the algorithm is also important. The mathematical definition of the Fibonacci number can be written as fib(N) = fib(N-1) + fib(N-2). These instructions naturally suggest a recursive algorithm, however, recursive algorithms are not suitable for very large arguments due to the resulting recursion depth. Since every recursive algorithm has an iterative equivalent, an iterative approach might be a better solution.
Neither recursive nor iterative "brute force" implementations are suitable for very large arguments N, as the processing time is a function of N itself. Therefore, depending on the exact understanding of the problem, a different algorithm may need inventing.
Once the problem and its preconditions are understood, the algorithm and programming language is chosen, the solution is implemented in edit/test cycles. This process is the same whether an assembly or a higher-level language is chosen.
The exact sequence of the instructions in the chosen language depends on the choice of language, algorithm and the exact understanding of the problem. For assembly languages, the exact sequence of instructions further depend on the choice of one specific assembly language, given that each processor family has its own assembly language.
What is meant by Data Consolidation?
Data consolidation simply means collecting and integrating data from two or more different sources to provide a single, consolidated data source, in order to reduce inefficiencies such as data duplication and making it easier to present data without the overhead of multiple data resources and the costs incurred in managing separate data sources.
How does data modelling lead to the design of a database?
The data model identifies the objects/entities involved in the application and the relationships between them. From that, the ER diagram is solidified and this forms the basis of the database design.
A database can be created using DML (data manipulation language). Example create table table_name (name datatype , name datatype...... ) .
How are the different relations in a relational database tied together?
There must be at least one common field in the tables that are related. In simple terms you find a value in that field in one table and then find the corresponding value for that field in another. At least one of them will be unique, like in a one to many relationship. One the one table, that value can appear only once in the table. On the many table it can appear more than once. In a one to one relationship, each can only appear once in each table in the relationship. In a many to many relationship, an intermediate table is set up and two other tables are joined to it.
Why do you learn database model?
It helps you to design a database. It is a theoretical idea of what it will be like. There are different models than can be used, such as relational or network or hierarchical. Some are better suited to some kinds of databases. Using the model helps people to design and build better databases.
What does it mean that the stack is a LIFO structure?
LIFO stands for Last In First Out. It basically means that the most recent piece of data added to a list, will be the first piece that is taken off. It is often compared to a stack of plates. When you have a plate to add to the the stack, you put it on the top, not in the middle or at the bottom of the stack. If you need a plate you usually take it from the top, not the middle or bottom. So the most recent plate on the top is the first that will be taken off when one is needed.
What are the major disadvantage of file processing system?
File processing system is inconsistent and disintegrared.It is difficult to access and may be present on different platforms which would not allow to integrate data
What does it mean to sort a record in a database?
When you report the content of a data base - (run a query) You may have the option of sorting it in to numeric order, alphabetical order etc - this can make reading the data easier. I.e. the list of sports clubs sorted in to the descending order of points won , this would find the top winner. A telephone list sorted by last name to make it alphabetical
When would you have a table with a relationship to itself what's an example of this?
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
It would be a case where two different fields in the same table are related to each other. Say you had an employee table, where each employee had an employee number field and a field with the employee number of the person they reported to. Say the two fields were Employee Number and Reports To. The person they reported to, would themselves be an employee. This would mean that each number in the Reports To field could be found somewhere else in the table in the Employee Number field.
If you were running a query to find the name of an employee and the name of the person they reported to, you would display the employee name, then look at the Reports To field, take its value and then look down the Employee Number field to find that number in order to get the name of the person the employee reports to. So the Reports To field would be linking to the Employee Number field, both of which are in the same table.
Do flat panel monitors use LED technology?
Some do, some don't. Older flat panel displays use a flat shaped florescent lamp. Newer flat panel displays use white LED's which use less current and produce less heat. This has the effect of extending battery life on portable devices. LEDS are also less susceptible to shock damage.
When registering with a software company what is the purpose and benefits or registering?
Benefits:
- When registering you may get additional functionality of the product. Some companies use this as a means to enforce licensing of their products.
- Many software companies use the registration to create push lists for patches, updates, and important notifications.
- Registered users often recieve notifications of special offers and promotions that may be of interest to them.
- Sometimes software companies will provide free gifts to those who register as an incentive. The free gift might be addional software or some cheap swag like a thumb drive, mug, or t-shirt.
Additional purposes:
- The software company is able to compile a database of current users who are then potential future customers for additional products.
- Some companies will share or sell the information with other companies for financial gain (Remember to read the privacy policy statement of the company before you register!)
What is an attribute and how many types?
An attribute in the database terms is called as fields. A group of fields is known as a record or tuple. Attributes can be either simple or composite and single or multi-valued .
What is the process that places records in order-alphabetical or numerical-using one of the fields?
The process of organizing records in some order based on some criteria is called sorting.
