Reference no: EM131098621
Question A
1. Create an entity-relationship diagram (ERD) based on the following information.
At a community college, courses are offered as course sections but some semesters some courses might not be offered. In order to manage these courses, selected faculty members are served as courses coordinators. One faculty member is assigned as course coordinator to oversee the course, and each faculty member can be coordinator of many courses. A student enrolls in many course sections and each course section contains many students.
For each ERD, identify reasonable entities and their relationships (one-to-one, one-to-many, or many-to-many) using the crow's foot notation among these entities.
Question B
A summary of business activities for enrolling courses for students and for enrolledclass lists for faculty members at an online university is as follows:
An academic department provides information on offered courses. Students request enrollment in offered courses and the system sends to each student an enrollment schedule. Faculty members receive enrolled class lists when the registration period is complete.
1. Draw a context-level data flow diagram for the "Courses Registration" system using the following "recommended" items (but you can develop your own items,
if preferred)
Process name: Courses registration system
External entities: Student, Academic department, and Faculty member
Data flows: Derived from the above narrative.
2. Explode the above context-level diagram by drawing the logical data flow diagram level 0 showing all the major processes using the following "recommended" items (but you can develop your own items, if preferred)
Process names:
(1) Schedule course
(2) Enroll student
(3) Produce class list
Data stores:
(1) Offered courses
(2) Course enrollment
(3) Students
External entities: Student, Academic department, and Faculty member
Data flows: Derived from the above narrative.
What is a common business application of voip at present
: What is the advantage and disadvantage of replacing a traditional PBX-type phone system with a wireless IP phone? What is a common business application of VoIP at present? What is the strategic advantage of using VoIP foe this application?
|
Stock index rather than actively managing portfolio
: Shen and Valerie are building their portfolios. Shen purchases shares in a mutual fund and pays fees to a manager who actively manages the mutual fund's portfolio. He does so because he believes that the manager can identify inexpensive stocks that w..
|
Find the inverse supply curve
: The supply curve for product X is given by QXS = -420 + 20PX. Find the inverse supply curve. How much surplus do producers receive when QX = 380? When QX = 1,060
|
Government fiscal policy and international trade
: Government fiscal policy and international trade seem to be linked. Let’s investigate their relationship.
|
Create an entity-relationship diagram
: For each ERD, identify reasonable entities and their relationships (one-to-one, one-to-many, or many-to-many) using the crow's foot notation among these entities.
|
Behavior necessarily violate the cost-benefit principle
: John, who earns more than $50000/year working at his full-time job, spends 40 hours splitting and stacking two cords of firewood over the course of many weekends in the spring and summer. Firewood—split and stacked—costs $200 per cord. Based on this ..
|
What is straight line depreciation charge for first year
: An asset was purchased for $70,000, has a salvage value of $10,000, and has a useful life of 10 years. If the asset is placed in service on May 1 { the company's fiscal year runs from January 1 to December 31 },, what is its straight line depreciatio..
|
Typical hierarchy chart for a program
: Draw a typical hierarchy chart for a program that produces a monthly bill for a cell phone customer. Try to think of at least 10 separate modules that might be included. For example, one module might calculate the charge for daytime phone minutes ..
|
Assume consumer spending is given by the equation
: Assume consumer spending is given by the equation C = 275 + 0.8[Y - T], investment spending is equal to 425, government spending is equal to 250, and taxes (T) are equal to 250, while full employment real GDP is equal to 4050. According to the simple..
|