Problem 1.

How would i represent this?

CIS305 Project 1

Project Description

The project is designing a complete database management system to address a practical database need and implement a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization.

The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of CPP University. The initial entities for your model are STUDENT, COURSE, and INSTRUCTOR. In addition to these initial entities, you are provided with several business rules.

You should treat this project as a business assignment in which your instructor is your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as inaccurate or incomplete work. Your grade represents your pay.

Initial Entities.

STUDENT ( StudentID, StudentName, StudentAddress, StudentPhone, StudentEmail, StudentDOB, StudentMajor, GPA)

COURSE (CourseID, CourseName, CreditHours,)

INSTRUCTOR( InstructorID, InstructorName, InstructorAddress, InstructorPhone, InstructorEmail, Salary)

Deliverable 1

Begin with the initial entities for STUDENT, INSTRUCTOR, and COURSE provided above, transform them into RELATIONS, and normalize your model to 3rd Normal Form. This is your deliverable #1. Realize that the three entities (or the three converted relations) are not in 3rd Normal Form. This is obvious by the many-to-many relationship that would need to exist between INSTRUCTOR and COURSE, COURSE and STUDENT, INSTRUCTOR and STUDENT.

You are to do the steps necessary to obtain 3rd Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come with (and their relationships) once you have achieved 3rd Normal Form. Hint: Your answer will be within the Word document you submit as your Project 1 Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships). This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships.

Deliverable 2

In Deliverable 2 you will start with a copy of your Deliverable 1, and build upon it by adding the necessary functionality to support the following business rules:

Business Rules: In addition to the following business rules, make sure to add any other business rules based on your assumptions:

INSTRUCTOR may teach one or more courses and each COURSE could be taught by one or more INSTRUCTORS.

Many STUDENTS may take many COURSES, and each COURSE may have many Students.

Each Student is required to take many COURSES

Each COURSE can have one or more SECTIONS, and each SECTION belongs to one COURSE.

Feel free to add any other business rules

In Deliverable 2, You will add the additional relations and relationships to the relational schema you created in Deliverable 1. You must maintain 3rd Normal Form in this enhanced model. Be sure to list your relations in alphabetical order and be sure to include the relationships between the relations (all of these lines may look a little messy). Also, keep in mind that all of the relations must be shown flush left against the left margin of the page and in alphabetical order. Be sure to use the correct capitalization formatting with RELATION names being singular and, in ALL CAPS, while attributes are presented using Proper Camel notation. Remember that this logical schema is a listing of the relations and relationships, and it is not in the same format as an ERD. Also, make sure to show the functional dependencies (Full, Partial, Transitive)

Deliverable 3

Contains the same information as Deliverable 2, except in a different format. Deliverable 3 is an Entity Relationship Diagram (ERD) that you develop in ERwin. All of the functionality indicated in the business rules must be present. Also, this exercise is an excellent opportunity to show your understanding of Enhanced Entity Relationship Diagrams (EERD), as you will have the opportunity to demonstrate Supertype/Subtypes. A helpful hint here is to take a screenshot of your ERwin ERD instead of printing it. Erwin places a big watermark description across the page when you print using the free Community Edition of the software; however, if you simply take a screenshot, then the watermark does not appear. All entities, attributes, and relationships must be properly labeled. Although they are presented in different visual formats, the information contained on this Deliverable 3 ERwin logical data model (ERD) must exactly correspond to the information contained on Logical Schema of deliverable

Submitting project assignments: (from your course Syllabus)

All projects assignments must adhere to the standards detailed below:

The second page must document the table of contents.

The third page must contain a statement attesting to the student's academic honesty and the student's name and signature. The statement of academic honesty will be provided with each project's instructions.

Subsequent pages must be logically arranged to accommodate the required deliverables.

Note: If any part of the above (Submitting Project Assignments Section) is missing, points will be deducted from your report accordingly.

Deliverable tips:

Within a Word document, submit all three deliverables in the exact order specified.

o Deliverable 1 with consist of the logical schema showing the relations and relationships

o Deliverable 2 will be in the same formation as Deliverable 1, but it will contain many more relations and relationships

o Deliverable 3 will contain the same information as Deliverable 2 but it will be in a different format. Deliverable 3 will be in the format of an ERD, and you will develop your ERD in ERwin. You must also attach a copy of your ERwin file.

Question.

a. What is cost-benefit analysis? How would you apply cost-benefit analysis to your decision to go to college? What are the benefits and what are the costs of going to college? b. What happens to your analysis if the interest rate rises? What happens if the payoff period shrinks? Who is more likely to find college economically worthwhile: you for your 63-year-old professor? c. How would you apply cost-benefit analysis to environmental policy? What are the costs of pollution? What are the benefits? Who receives the benefits, and who bears the costs? When the benefits in the costs are received in different times, how can you compare them? What happens if you use a lower discount rate or a higher one?O only aggregate demand. Question 48 1 pts The economy is in long-run equilibrium when () short-run aggregate supply intersects long-run aggregate supply. O aggregate demand intersects short-run aggregate supply. O aggregate demand intersects both long-run and short-run aggregate supply. the inflation rate is equal to zero. O aggregate demand intersects long-run aggregate supply. 1 pts Question 49Question 2 (0.3 points) The drop in housing values has a wealth effect that most directly affects which component of aggregate demand? Question 2 options: Government Purchases Investment Consumption Net Exports Question 3 (0.3 points) The drop in new housing construction most directly affects which component of aggregate demand? Question 3 options: Net Exports Government Purchases Consumption InvestmentPlease tell me and your classmates about your thoughts on the following questions: 1. What is the marginal cost and marginal benefit? How do you use the concepts of marginal cost and marginal benet when making decisions daily? The goal is for us to evaluate how often we use a benefit-cost analysis in marginal terms in our daily lives, without realizing it, and how to improve our decision-making after a careful evaluation of all relevant costs and benets involved. 2. What is your opportunity cost of attending classes on campus? For the purposes of keeping things simple, focus on finding the opportunity cost. expressed as a dollar amOunt of your opportunity cost of attending a onehour class on campus. First, find all yOur alternatives to attending class. Then assign a dollar value to each aloemative. Next rank your alternatives, and last, based on the highest ranked alternative, share your opportunity cost. Since you have made the decision to take this course online, how would your opportunity cost compare to that of another student already taking the same course on campus. Explain