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
A database can perform four core operations, known as CRUD (Create, Read, Update, and Delete). Create is the ability to insert information into the database. Read is the ability to retrieve stored data, possibly transforming it during this process. Update refers to the ability to store newer information in place of older information. Delete refers to the ability to remove data that is no longer needed.
How would you structure a database for tracking a family tree?
Identify the entities in the database
Select the unique identifier/primary key
Identify appropriate attributes
Select the appropriate data types
Create a recursive relationship
Identify the cardinality of a relationship
How would a travel agent use a database?
to keep track of all customers and resort info also flight information
What are one to many and many to many Relationship in database?
Relationships happen between two tables.
One to Many means that one objects (called tuples, or rows) of Table A is related to one or more objects in Table B.
For example, if a doctor can work only in one hospital, and we have a table of hospitals and a table of doctors, Hospitals has a One to Many relationship with Doctors, because for each hospital you will have one or more doctors working at it.
Many to Many means that for each object in Table A, one or more objects in Table B are associated, and viceversa.
In the example, if doctors are allowed to work in different hospitals, the table Hospitals and the table Doctors have a Many to Many relationship.
Now, how to implement this in a relationship DB, that is another question.
To make generalizations about future events based on inferences from data?
Prediction... Foretelling... Extrapolation...
What is the advantages and disadvantages of manual data capture?
Advantages:
- More accurate information: An interviewer is able to get the exact thoughts and feelings of the person being interviewed, instead of just a single answer.
- Can be stored for later use: If a computer saves too much data it will eventually run out of space.
- Lower cost: It may be cheaper to buy writing materials rather than buying computers
Disadvantages:
- It is hard, tiring work: Most people prefer to sit at a computer and type all day rather than to run around interviewing thousands of people in a day.
- Lack of space: It takes less space to save documents on a computer than to file millions of papers.
- Speed: Sometimes it takes a long time to type information into a computer.
What are all the kinds of bytes?
this is in order from samllest to biggest :
Bit = 1bit
Byte = 8bits
Kilobyte (kB) = 1024 bytes or 10^3
Megabyte (MB) = 1048576 bytes or 10^6
Gigabyte (GB) = 1073741824 bytes or 10^9
Terabyte (TB) = 1099511627776 bytes or 10^12
Petabyte (PB) = 10^15 bytes
Exabyte (EB) = 10^18 bytes
Zettabyte (ZB) = 10^21 bytes
yottabyte (YB) = 10^24 bytes
(this is as far as i know)
Propagation of operation in object modeling?
Propagation means triggering ie something which fires automatically. Thepropogation of operation is applied with aggregation, if some operation is applied with the high level aggrigate the same operation will be performed with all lower aggregates. For example in aggregation between document and paragraph if we will perform an operation copy with document it will automatically applied with paragraph also. This propagation of operation.
kailash
Unless I am mistaken. A group(ed) file is named based upon the "type" of host program or directory you are downloading it from, or keeping it on. Whether it be a music, or video file. It really just depends.
entity is an object with physical existence(car, house, person) or with conceptual existence (company, university course)
How can you apply McKinsey's 7S model to any food business?
The famous McKinsey's 7S model comprises of the major foundations which are essential to efficient operations of any enterprise. The 7Ss stand for
- Shared Value - this is the most innate belief/values on which any organization is built
- Strategy
- Structure
- System
- Staff
- Style
- Skill
In a datasheet which mode assumes that you are trying to change the value of a particular field?
Edit mode
Could you please Draw a data flow diagram for ordering supplies for a barber shop?
A data flow diagram for ordering supplies for a barber shop would include key processes such as "Identify Supply Needs," "Place Order," and "Receive Supplies." The flow would show data inputs like "Current Inventory" and "Supplier Information" feeding into the "Identify Supply Needs" process. Outputs from "Place Order" would include "Order Confirmation" sent to suppliers, while the "Receive Supplies" process would involve updating "Inventory Records." Arrows would indicate the flow of information between these processes and external entities like suppliers.
If the dropped table is a base table for a view , then dbms like oracle invalidates these dependent views but does not drop them. But you cannot use these unless you re-create the table.
making the system available
