Reference no: EM13328188
Definition of the systems analyst's role and responsibilities.
Systems Development Lifecycles.
Structured Methodologies, Data Flow Diagrams, Entity Relationship diagrams, Structured English, Decision Tables and Cohesion/coupling.
Data analysis: identification of data requirements from different user perspectives, Data definition, documenting results from data analysis, data models/notation, data dictionaries, use of supportive software including database products and data modelling software tools.
Top-down analysis: entity analysis techniques, entities, attributes, key identifiers, relationship types and enterprise rules, entity relation diagrams (ERDs), degrees of a relationship. Use of Yourdon
Relational Model: the relational model and relational operation, bottom-up analysis, introduction to problems of redundancy, update anomalies, purpose of normalisation, functional dependency, determinacy diagrams and identification of unnormalised data structures, development of first, second and third normal forms
Query: query languages and use of query by example (QBE) to extract meaningful data, including formatting and use of functions/ formulae Data manipulation: use of query languages and visual tools for database maintenance, inserts, updates and amendments of data.
Relational Algebra: common functions of SQL language (Union, Intersection, difference and product)
Implement a design: select suitable data types, entity and referential constraints, convert logical database design to physical implementation using appropriate visual tools and structured query languages.
Teaching and Learning Strategies
Formal lectures will be used to introduce each topic within the module and students will explore them through web-based training, supervised exercise sessions, directed practicals and unsupervised workshop sessions. Learning and practical sessions will be fully integrated with all units and will hence supplement and complement each other.
|
Determine what will be the rate of return on the bond
: A 2-year maturity bond with face value of $1,000 makes annual coupon payments of $106 and is selling at face value. What will be the rate of return on the bond if its yield to maturity at the end of the year
|
|
Water in an enclosed vessel at 17°c contains a concentration
: Water in an enclosed vessel at 17°C contains a concentration of dissolved oxygen of 6 mg/L. At equilibrium, determine the concentration of oxygen in the space above the water in molal fraction. and the total pressure in the vessel. Henry's law con..
|
|
How much will have if makes deposits for 50 years
: If you deposit $5,200 at the end of each of the next 25 years into an account paying 10.30 percent interest, how much money will you have in the account in 25 years
|
|
Evaluate the dew point of the stack gas
: The flue gas analysis. The few gas analysis shows as carbon dioxide 14%, carbon monoxide 0.4%, oxygen 5.6% and nitrogen 80%. The air used has a dew point of 50°F. The barometer shows 29.9 inches of mercury. Calculate the dew point of the stack gas..
|
|
Identification of data requirements from different user
: Structured Methodologies, Data Flow Diagrams, Entity Relationship diagrams, Structured English, Decision Tables and Cohesion/coupling.
|
|
Find out the dew point temperature of the flue gas
: Ethane is burned with 20% excess air in a furnace operating at a pressure of 100 kPa. Assume complete combustion occurs. Determine the dew point temperature of the flue gas.
|
|
What is the gravitational force between mars and earth
: Earth is about 150 trillion meters from the Sun, while Mars is about 230 trillion meters from the Sun. What is the gravitational force between Mars and Earth
|
|
Explain what temperature should you cool the air
: Air at 25°C and 100 kPa has a dew point of 16°C. If you want to remove 50% of the initial moisture in the air (at a constant pressure of 100 kPa), to what temperature should you cool the air
|
|
What is the net forward force on the box
: A box weighing 200 N is dragged across a gravel surface with an applied force of 100 N. What is the net forward force on the box
|