Skip to main content

The college keeps information about students and student performance. Every student is known by her/his first name, initials and last name

create an ER Diagram for the scenario described below.
You are commissioned to design a database to keep records of a small college. You talked with various key members of this community and obtained the following information: 
  1. The college keeps information about students and student performance. Every student is known by her/his first name, initials and last name. They are also identified by a unique StudentID provided by the University. Every student also belongs to one of five Schools (Arts & Sciences, Education, Management, Music and Engineering), and has a Major within that School (History, Chemistry, etc.). All programs of study require 4 years of study, and students are classified as freshmen, sophomore, junior, or senior, depending of the year that are currently attending. Each student is assigned and advisor from Faculty.
  2. The college also keeps track of Faculty information. Besides their first name, initials and last name, Faculty members are also issued a unique FacultyID for the institution. Each one is also given an official title for their position in the University, an office number and a telephone number.
  3. Every school within the college has a number of different departments. Each department may offer courses identified by a unique CourseID (i.e. IS361). They also have a course name, and a number of credits hours they are worth for.
  4. Every semester the departments offer some of the courses associated with them. These offerings are uniquely identified by a Semester and a List number. There are 3 semesters per year (Fall, Spring and Summer) and they are given a name that includes the year, i.e.: Fall 2016 or Spring 2017. A List Number is unique within a semester, but it may be repeated from semester to semester and assigned to different courses between semesters. Different sections of the same course within a semester are assigned different List Numbers. Besides referencing a course, every offering also identifies the faculty member who will teach the course, and the classroom number.
  5. When a semester ends, student's grades are stored in a file of Official Records that references the student, the semester, the list number, and the final grade (A, B, C, D, F or I).
  6. The college also wants to keep track of student associations that are advised by a Faculty member. To this effect they give each of these associations a unique AssociationID and an official name. Each association must have only one advisor, but any student may belong to as many associations as they want. A list of all student members of each association is also kept up-to-date.
  7. Assignment status: Solved by our Writing Team
  8. Source@PrimeWritersBay.com
    9.  GET THIS PAPER COMPLETED FOR YOU FROM THE WRITING EXPERTS  CLICK HERE TO ORDER 100% ORIGINAL PAPERS AT PrimeWritersBay.com

Comments

Post a Comment

Popular posts from this blog

Identify and discuss a key milestone in the history of computers that interests you and why.

  Part 1Title: Lab ResponseDiscuss one feature of MS Word and one feature of MS Excel that you found challenging within the lab and why. Examples are WordArt, inserting shapes, adding borders, cell styles, etc. This response should be at least one paragraph in length. Part 2Title: History of Computers Identify and discuss a key milestone in the history of computers that interests you and why. This section should be at least one paragraph. Part 3Title: System Software vs. Application Software In your words, explain the difference between application software and system software as if to another coworker who has limited technical knowledge. Use examples to support your rationalization. This section should be at least two paragraphs. Part 4Title: Blockchain and Cryptocurrency In a minimum of one paragraph each: 1. Conduct some research on the internet and discuss one underlying technology of cryptocurrencies like blockchain, cryptography, distributed ledger technol...
Post a Comment
Read more

Cybersecurity and Infrastructure Security (CISA)

 Develop a research paper that identifies a specific Department of Homeland Security (DHS) operating agency. Fully describe 1 DHS operating agency from the following list: Cybersecurity and Infrastructure Security (CISA) U.S. Customs and Border Protection (CBP) U.S. Citizenship and Immigration Services (USCIS) Federal Emergency Management Agency (FEMA) U.S. Coast Guard (USCG) U.S. Immigration and Customs Enforcement (ICE) U.S. Secret Service (USSS) Transportation Security Administration (TSA) The information must include a discussion of the selected DHS agency. Identify the agency’s mission, goals, objectives, and metrics. Conduct an analysis of how these mission areas address the threats or challenges. Recommend agency program priorities among the current set of goals, objectives, metrics, or budget items. Justification of all choices is an essential element of this assignment. Reference all source material and citations using APA format. WE OFF...
Post a Comment
Read more

Discuss how the project

ord count : no idea 1. You are required to write a report on all project activities involved in all the 10 knowledge areas of project management for the entire project life cycle. You should also include a list of the respective PM documents, for example PM Plan, PM Quality Management Plan, Risk management, Procurement, etc. The report must include the activities that are considered before the project is closed out. 2. Discuss how the project quality management plan can provide adequate standards and controls in managing global teams in projects. Your discussion must provide adequate arguments for the need of cultural awareness and legal issues. Regards, The post Discuss how the project appeared first on My Assignment Tutor . Assignment status :  Resolved by our Writing Team Source@ PrimeWritersBay.com GET THIS PAPER COMPLETED FOR YOU FROM THE WRITING EXPERTS   CLICK HERE TO ORDER 100% ORIGINAL PAPERS AT PrimeWritersBay.com NO PLAGIARISM
Post a Comment
Read more