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
A starflake schema is a combination of a star schema and a snowflake schema. Starflake schemas are snowflake schemas where only some of the dimension tables have been denormalized. hardkingofflirt@gmail.com
What are the characteristics of MIS?
Characteristics of MIS:
1. Management oriented: The system is designed form the top to work downwards. It does not mean that the system is designed to provide information directly to the top management. Other levels of management are also provided with relevant information.
2. Management directed: Management orientation of MIS, it is necessary that management should continuously make reviews. For example, in the marketing information system, the management must determine what sales information is necessary to improve its control over marketing operations.
3. Integrated: The word 'integration' means that system has to cover of all the functional areas of an organization so as to produce more meaningful management information, with a view to achieving the objectives of the organization. It has to consider various sub-Systems, their objectives, information needs, and recognize the independence, that these sub-systems have amongst themselves, so that common areas of information are identified and processed without repetition and overlapping. For example, in the development of an effective production scheduling system, a proper balance amongst the following factors is desired:
I. Set up costs
ii. Overtime
iii. Manpower
iv. Production capacity
v. Inventory level
vi. Money available
vii. Customer service.
4. Common data flows: The integration concept of MIS, common data flow concept avoids repetition and overlapping in data collection and storage, combining similar functions, and simplifying operations wherever possible. For example, in the marketing operations, orders received for goods become the basis billing of goods ordered, setting up of the accounts receivable, initiating production activity, sales analysis and forecasting etc.
5. Heavy element: A management information system cannot be established overnight. It takes almost 2 to 4 years to establish it successfully in an organization. Hence, long-term planning is required for MIS development in order to fulfill the future needs and objectives of the organization. The designer of an information system should therefore ensure that it would not become obsolete before it actually gets into operation. An example of such a feature of MIS may be seen in a transportation system where a highway is designed not to handle today's traffic requirements but to handle the traffic requirements five to ten years.
6. Flexibility and ease of use: While building an MIS system all types of possible means, which may occur in future, are added to make it flexible. A feature that often goes with flexibility is the ease of use. The MIS should be able to incorporate all those features that make it readily accessible to wide range of users with easy usability.
A relational model is the means of ordering elements that relates to one another, called a tuple.
Multiple tuples of similar structure can be seen as a table, with rows that describe each tuple, and similar elements ordered in columns.
All operation are described as binary operation as in calculus, e.g. "Insert" is the same as addition, as a new relation is added, where the elements in the relation constitutes a new unique group of values.
Any tuple can have a relation to another tuple - such as "they belong together" or "one comes after the other".
That relations can be represented as tables is used by a number of application building tools, such as MS Access. These refer to the similar elements - the column by assigning them names. They will usually also assume a similar datatype (int, numeric text, float, code, text, etc). The relation model is entirely based on mathematics, relational calculus and relational algebra developed by Chris Data and Ted Codd at Watson Height, IBM Research Center.
The relational model does not relate to any relationship between the tables, and relationships needs to be coded by the application programmer that use codes to make e.g. a parent relates to child. The database system can implement constraints such as that every child has a parent, while not every person has a child.
The model is then used by application developers to create the user interface.
The competing model is the CODASYL network model that was made to satisfy the requirements for application support. This will provide "pointers" that can link a child to a parent, and an order line to a order. However, these does not lend themselves to allow generic tools such MS Access to make the applications, as it does not support the flexibility needed to "just make it".
What is centralized decision making?
Centralized decision making is whereby a top manager retain most decision- making power to him/her self.
How is security implemented in a relational database?
Security is one of the key concern of a database administrator. Security can be added to the user, object etc. An object (table,views,stored procedures etc) can have multiple permissions. A database administrator can grant revoke permissions to the objects. Security is implemented based on the data sensitiveness also. If there is a table for password, make sure that only it's encrypted and can be accessible through administrator only.
A WORM drive is a type of CD writer. WORM is short for "Write Once, Read Many." So that just means it can write to CD-R (recordable) discs once, and that the resulting CDs can be used quite a few times (until scratched up or exposed to lots of UV light). That is different from CD-RW (rewritable) which means it can be written to a few times or so and read many times.
Another thing called a worm is similar to a virus but spreads over a network. If you have one in your computer, you would need an antivirus or other malware removal software to remove it. A worm can be used to launch denial of service attacks against other machines. The worm may take orders from an IRC channel and many infected machines could be told to attack a certain IP address and prevent it from using the Internet.
What is the Difference between an architect and a dba?
An architect is someone who designs the business rules and physical layout of the database. A DBA maintains the database environment, and depending on the extent of the DBA's skills also does the database programming. In doing so executes the architects vision.
How do you create a login page with user name and password fields?
It is quite simple to create a login page, it is simply a form input, if all the people hold the same username and password. If you want and I suspect you do, a unique service, then you will need to install a database. I have no experience of this.
What are the advantages of direct conversion?
The advantage of this strategy is that it requires no transition costs and is a quick.
When creating a table every field in Access must have what two things associated with it?
Every field must have a name. They also must have a data type. For some field types, you also need to have a size, though a default size will be set for those fields.
Your library is corrupt.
What is data quality specialist?
We specialise in recovering data from a variety of devices capable of storing user's data. We offer the most comprehensive Data recovery service in the UK.Plymouth Data Recovery specialises in recovering data from a wide range of devices capable of storing data. We recover data from PCs, External HDDs, Laptops, RAID setups and a whole host of removable storage devices. We have 15+ years experience in the field of data recovery and carry out 1000s of recoveries annually.
http://www.plymouthdatarecovery.co.uk/
Relationship between CAD and CAM?
The relationship between CAD (Computer aided design) and CAM (computer aided manufacturing) is that both types of designing need to be done on a computer and operated by an engineer.
Give the Name of 10 situations that can be represented by means of graphs?
Financial history Score history Statistical analysis data set averages data set trends time value of money usage statistics performance statistics personal achievement trends grade history and analysis time vs. productivity models
RDBMS is short for Relational database management system . RDBMS defines relationship between the tables . MPP stands for massive parallel processing and in RDBMS MPP refers to the processing of several table ,that are in relation with one another together.
What is Procedural query language?
A procedural language is nothing but what we call relational algebra. Procedural language is just like SQL but with different syntax. In Procedural language for "Select" we use projection and for "where" clause we use selection.
