SYSTEM SOFTWARE UNI QUESTIONs

Free Downl...

Read more »

Assignment – III

Subject : Structured & Object Oriented Analysis & Design Methodology Subject Code : 630001 Department : MCA Assignment Date : 22th Aug, 2010 Submission Date : 30th Aug, 2010 Assignment – III List advantages of using data flow approaches. What is the difference between Logical DFD and Physical DFD? Define Following terms (a)    Event Response Table(b)   Trigger(c)    Base Element(d)   Derived Element(e)    Primitive ProcessWhat is partitioning? List reasons for partitioning DFD. Define the terms (a)    Data Dictionary(b)   Metadata(c)    Data Repository(d)   DTDList need for understanding the Data Dictionary. Explain with...

Read more »

ACCOUNT(LEDGER)

LEDGERThe complete set of accounts for a business entry is called a general ledger. It is the “reference book” of the accounting system and is used to classify and summarize transactions and to prepare data for financial statements. It is also a valuable source of information for managerial purposes, giving for example the amount of sales for the period or the cash balance at the end of the period.SPECIMEN RULING OF LEDGERFrom the above specimen rulings of ledger account, we can observe the following points:1.    Ledger Account is usually in the “T” form which contains two sides-Debit side and Credit side.2.    Left hand side is called Debit Side (Dr.)3.    Right hand side is called Credit Side (Cr.)4.    Each side further divided...

Read more »

Joining Tables in SQL Queries

Joining Tables in SQL QueriesTypes of JoinsSometimes it is necessary to work with multiple tables as though they were a single entity. Then a single SQL sentence can manipulate data from all the tables. Joins are used to achieve this. Tables are joined on columns that have the same data type and data width in the tables.While different implementations have many ways of joining tables, the most common  types of joins areEQUIJOINS / INNER JOINSNATURAL JOINS NON-EQUIJOINS OUTER JOINS SELF JOINS CROSS JOINSyntax:      ANSI-styleSELECT<(columnName1)>,<columnName2>,<(columnName N)>           FROM<Table Name1>                       ...

Read more »