-
Describe collage as system?
Describe your university or college as a system.
What is the input?
What is output?
What is the boundary?
What is the components and their relationship?
The constraint
The environment
Draw a diagram of this system
-
What is the difference between star flake and snow flake schema?
Read Best Answer
Editorial / Best Answer
zahoorahmad- Member Since Apr-2006 | Apr 12th, 2006
Star Schema:
Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.
SnowFlake:
Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.
Wassim Saade
- Nov 23rd, 2011
Star flake schema's are snowflake schema's where only some of the dimension tables have been denormalized.
Every star flake schema is also a snowflake schema.
Not every snowflake schema is a starflake schema.
A snowflake schema with all of its dimension tables normalized is not a starflake schema.
-
Logical Database design
Discuss how you would use Storage structures mainly the tablespaces, Database Security features, Oracle Net services to logically manage what users can do or not to the database. Assume you would want to achieve partial database availability to different users at some times so that whilst some users can be able to access the database you disable some group from using the database or just change what...
-
Informatica Architecture
Can you Explain about Informatica Architecture ? and what difference between service based and service oriented ?
Read Best Answer
Editorial / Best Answer
Answered by: venkatesh
- Sep 21st, 2011
|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-------------------------------- | | | |powercenter repositery | | | |------------------------------- | | |________________|repositery server | | --------------------------------|-------------------|
venkatesh
- Sep 21st, 2011
|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-...
-
Client Dependent table
What are the values given to the Field name,Data element and Type of a table to make it as a client dependent ?
-
-
-
What is ERD?
-
Data Modeling
What is the impact of Data Modeling Software Engineering?
JayashreePatil
- Jul 2nd, 2008
GUI Representation of a Data model of any system helps in understanding the data flow and relationship between the entities.
-
Is this statement TRUE or FALSE – all databases must be in third normal form?
osnarayan
- Sep 14th, 2009
Yes. It is true that all the database should be in the third normal form. Hope, Third Normal Form is sufficient to tune the database and make it perfect. 4th Normal Form onwards it is not at all requi...
venky
- May 23rd, 2006
False, all databases need not be in 3NF, however in most cases in the business world databases tend to be in 3NF or BCNF
-
Scrum Development in respects to the Burndown Chart
One popular tool in scrum development is the burndown chart, which diagrams the day-to-day progress that a scrum development team is making on a particular sprint. Essentially, at the end of each day in the sprint, the team estimates how many hours of work they still have to do to complete the sprint requirements. If all is going according to plan, the actual burndown will occur at the optimal rate,...
Joelaadams
- Jun 29th, 2010
Scrum sets out a fixed length for each Sprint (In classic SCRUM, 30 days or four weeks). Hence, if you are running ahead of schedule, it will be necessary to add tasks to avoid idle time at the ...
-
Agile Approaches
One feature that characterizes all of the agile approaches that have arisen in recent years is the requirement that software features be developed in small incremental cycles of two to six weeks in duration. Explain the positive and negative effects that this requirement produces with respect to the willingness of management to permit the adoption of agile processes.
priyanka2000
- Jun 17th, 2010
Positives: A customer demo can be given at the end of a sprint , hence if there is anything that the customer does not like , that can be captured , instead of propagating that throughout the delivery...
-
Data modelling is the process of constructing 1. An orderly arrangement of data elements 2. A graphic representation of data contained in an information system 3. Physical elements of the information system 4. A verbal description of the data need
-
Match the following in the context of data flow diagram :
i. circle a. source of data ii. square b. file or data base iii. arrow c. conversion process iv. parallel line d. data flow
1. l-a, ll-b,lll-c, lv-d
2. l-c, ll-a, lll-d, lv-b
3. l-c,ll-d, lll-a, lv-b
4. l-b, ll-a, lll-d, iv-canoosha kokkula
- Jul 2nd, 2009
Answer is 2Circle - Conversion processSquare - Source of data
Arrow - Data flowParallel line - File or databaseSashaFroyland
- Mar 2nd, 2008
None of the above (in my opinion).A -> C -> D -> bA) source, then data flows to C) where it's converted or transformed, then it flows to D) parallel where it's pipelined into the B) the database as both updates in inserts.
-
Data Options and Parameters
What is the distinction between data options and parameters?
seethala_goutham
- Jun 11th, 2009
Data options means it sends the data in diff forms and where as parameters supports the data which sends through it
-
Conceptual Models
What are Conceptual Mdels
jay_yasho
- Mar 31st, 2009
A conceptual ER model show how the business world sees the information. It shows only critical details in order to emphasize business rules and user objects. ideally It includes only significant...
-
Components of Information System Architecture
List six key components of Information System Architecture. Which of these relate to database design and Why?
MAbdullah47
- Feb 9th, 2009
1. Data 2. Processes 3. Network 4. People 5. Events and points in time 6. Reasons All of them related to the DB Design . During the database design we need data to define it’s attributes; proces...
-
Spiral Model and Risk Analysis
Specify and explain examples of the types of projects that benefit and the types of projects that suffer from the regular placement of risk analysis within the Spiral Model.
-
Relational and Dimensional Data Modeling
How does Relational Data Modeling differ from that of Dimensional Data Modeling?
wmilford
- Jan 16th, 2009
In relational models data is normalized to 1st, 2nd or 3rd Normal form. In dimensional models data is denormalized. The typical design is that of a Star where their is a central fact table containing...
-
When should you consider denormalization?
geeksds
- Sep 18th, 2008
When there are performance issues, that would be improved by denormalizing the database.
sachin
- Jun 25th, 2007
There are various reasons behind normalizing and denormalizing.If you dig deep into the practical world, everywhere all the applications have both type of formation. You cannot deal with only one type...
Data Modeling Interview Questions
Read Best Answer
Ans