Reference no: EM131267387
Let us consider the information that your school tracks for a class. In this instance, a class is a scheduled course. For example, your school may offer FINA 2100- Introduction to International Financial Markets as a course. If the school offers it in the fall, then it becomes a class. Below, we have provided some basic business rules and many pieces of information that your school probably tracks about the class:
A course may (or may not) require one or more prerequisite courses, and a course may (or may not) serve as a prerequisite of other courses.
Each course belongs to a specific department and a department can have many courses.
One or more sections of a course will be scheduled each semester at different times of the day and on different days of the week.
One instructor will teach a scheduled course section in a specific classroom. The same classroom can be used for many different course sections at different times.
A department has many instructors and an instructor may teach for multiple departments.
Part 1: Complete the table
Fill out the table by following these instructions:
1) For each piece of information that the school wants to track, identify if it is an entity or an attribute (place an X in the appropriate column).
2) For each recognized attribute, identify if it is a primary key with an X in the Primary Key column.
3) Identify the entity to which the Primary Key belongs (write the name of the entity in the last column).
The first three rows are filled in to provide an example of how the table should be completed.
Part 2: Write a detail document
Using the provided information, write a detail document about the various scenarios described in Part 1 with respect to entities and their relationships. The E-R diagram will be created from your findings. Don't worry about going through the normalization process at this point. Identify the appropriate relationships among the entities, and define the minimum and maximum cardinality of each relationship. Make some additional assumptions about the business rules, if necessary.
Part 3: Create an E-R Diagram
Draw the initial E-R diagram based on the given business rules and the scenarios you defined in your detail document. Include a screen shot or jpeg of the E-R diagram in the CT03 assignment document for submission.
|
Define your company target market
: Define your company's target market. Analyze the types of consumers who will be drinking your beverage in demographic terms (i.e., age, education level, income, gender, ethnic group, etc.)
|
|
Write a program to find the sum of the test scores input
: Write a C# program to find the sum of the test scores input by the user. Use this pseudocode as a guide to your design, in which the user inputs the number of test scores and each score.
|
|
How is the information age changing the nature of pricing
: Explain how discounts, geographic pricing, and other pricing tactics can be used to fine-tune the base price.- Write a memo analyzing the factors you need to consider in your decision.
|
|
What is the ergodic capacity of this channel
: Now assume that the transmitter can control the state of the channel and the receiver has access to channel state information. What is the capacity of the resulting channel?
|
|
Identify the entity to which the primary key belongs
: Draw the initial E-R diagram based on the given business rules and the scenarios you defined in your detail document. Include a screen shot or jpeg of the E-R diagram in the CT03 assignment document for submission.
|
|
Information security professionals association
: Select a non-profit cybersecurity organization. CIUSPA - The Credit Union Information Security Professionals Association Identify aspects of the selected non-profit organization that align with Identity as a Service (IDaaS). How would the organiza..
|
|
Develop a price line strategy for each of the firms
: Discuss product line pricing. - Develop a price line strategy for each of these firms: a college bookstore, a restaurant, a video rental firm.
|
|
Create a project in which the input is the number of minutes
: A local recording studio rents its facilities for $200 per hour. Management charges only for the number of minutes used. Create a project in which the input is the number of minutes it used the studio.
|
|
Develop the functional evolutionary maps of the markets
: Develop the functional evolutionary maps of the markets and industry in which the company is embedded. Create functional maps (time-based evolutionary maps) for technology, product market, and manufacturing strategy of the firm. These maps will be..
|