How is a composite entity represented in an ERD and what is its function?
A Composite Entity is represented by a collection of Inter-related Entity types which togather represent a business Concept. An example of this concept is a Person's Health Record, Equipment Record, Equipment Maintenance Record.
What is the difference between single-valued attributes and simple attributes?
single valued attribute are one character in a record
Alphabetic Data is in the form of Alphabets as well as space between two words. like Farhan ul Hasan , Karachi , Computer Studies etc.
What is an example of indexed sequential?
An example of indexed sequential access is a library catalog system. In this system, books are organized in a sequential manner by their titles or authors, but an index is maintained that allows users to quickly locate specific books based on keywords or categories. This hybrid approach combines the benefits of sequential access for browsing and indexed access for efficient searching.
What are pharmacy-benefits management firms?
Pharmacy-benefits management firms, or PBMs, are essentially intermediaries that negotiate discounts with pharmaceutical companies for large employers and managed-care insurers or health plans.
What is the difference between data model and schema in database?
As I understand it, a database schema is a physical entity, it describes the structure of exactly how the data is stored and is itself stored by DBMS for reference. Data model, on the other hand, is an abstract representation of database.
Part of AVG (anti virus software)
Hello Hans,
Please use latest version of AVG remover (build 1165), then remove all remained AVG folders* (if exist):
C:\Program files\AVG
C:\Documents and settings\All users\Application data\MFAData
C:\Documents and settings\All users\Application data\AVG8
C:\Documents and settings\All users\Application data\AVG9
C:\Documents and settings\All users\Application data\AVG10
Then check the AVG installation again. What is the current situation?
If the situation still persists, please gather (pack in an archive or zip file) latest AVG installation logs and "avgremover.log" from folder, where AVG remover has been run, upload the archive (zip file) to favorite online storage and provide us with link to uploaded file.
Thank you
* Some folders could be hidden by default Windows settings. To view hidden files and folders:
1. On the taskbar, click Start -> (Settings) -> Control Panel -> (Appearance and Personalization) -> Folder options.
2. Click the View tab.
3. Click ?Show hidden files and folders? (the name may vary depending on the operating system).
4. Click OK.
What is the structure and organization of data in a database called?
Data hierarchy is the structure and organization of data, which involves fields, records, and files. (c) Bidgoly MIS2.
Network Database
What is the difference between candidate key and primary key with example?
Any group of keys or columns (may be one or more than one) which can be used to uniquely refer to any row is together called as candidate key.
A primary key only one column name which can be used to uniquely refer any row.
there is no much difference b/w these two except the number of columns in consideration.
I am sure they do.
(although I have no direct knowledge of their data processing I cannot imagine that a company as large as Unilever would not have a great number of databases and so would need quite sophisticated database management systems to keep track of what they need to know!)
What are the characteristics of data in a data warehouse?
There are four key characteristics which separate the data warehouse from other major operational systems:
What do extension and intentions of relations mean in dbms?
What is the main four phases of query processing in dbms?
Query processing can be divided into four main phases: decomposition, optimization, code generation, and execution.
What are the different types of database languages?
Two main types:
Relational Calculus based Language
Relational Algebra based Language.
These languages provide similar set of operations but with different syntax. Calculus based is more kind of procedural and near to English, while Algebra based uses a set of symbols for queries.
How to insert values in to a table in SQL?
SELECT columns FROM tables INTO tablename - will create and insert values
INSERT INTO table SELECT columns FROM tables - will insert from one or more tables into a table
INSERT (columns) INTO table VALUES (literals) - will insert literal values into row in a table
What is the difference between data base and data base management system?
data base means a collection of data,which may be inter related.
data base management system is a collection of programs for managing the data base.
When managing a company's database the database requires a technical inside view of data.?
administrator
How do you use database technology to achieve product differentiation?
The term "product differentiation" refers to making a product stand out from others, to attract buyers from a particular segment. Database technology can help if it is sorted to display potential buyers from the target market.
What is directed data mining and undirected data mining?
In directed data mining, you are trying to predict a particular data point - the sales price of a house given information about other houses for sale in the neighborhood, for example.
In undirected data mining, you are trying to create groups of data, or find patterns in existing data - creating the "Soccer Mom" demographic group, for example. In effect, every U.S. census is data mining, as the government looks to gather data about everyone in the country and turn it into useful information.
How database help in your life?
Lots of people use databases, teachers, doctors even librarian's. For example, a librarian uses a database to keep information of all the people who borrow books from the library, their names, address, contact numbers and so on!!:)
What are disadvantages of pl-sql?
Disadvantages of Oracle PLSQL
If you're just running Oracle databases, there are no major disadvantages to using PL/SQL as long as you're aware of its limitations.
Proprietary to Oracle
PL/SQL is proprietary to Oracle which means if you were to change database vendors then you would have to re-write all your Oracle PL/SQL programs. Also if you use a mixture of databases or develop applications to run on different databases, you will either have to support lots of source code or write your applications in a database-neutral language like Java, VB or C and use the APIs to access the database.
Poor I/O Features
The other limitation of Oracle PL/SQL is that there is very little support for i/o either to read/write files or to read from or write to a user interface. The rationale behind this is that PLSQL is designed for manipulating information from the database and not for processing files or communicating with users. These operations are possible - they just require a little bit more effort!