GradePack

    • Home
    • Blog
Skip to content
bg
bg
bg
bg

GradePack

A university registrar’s office is designing a database with…

A university registrar’s office is designing a database with the following characteristics: It is necessary to store information about courses and their corresponding unique course number, title, credits, and syllabus. Note that the prerequisite courses for any specific course (main course) is also needed to be known. Since not all existing courses may be offered to students to take, the database must store information about all courses offered and available, together with their year, semester, section number, room, and time. A specific course can be offered many times, or not at all. Logically, an offered course must match a single existing course.  The database must also store information about instructors, their unique IDs, names, departments, and titles. An instructor must teach at least one course, but no more than 7. Also, a course offered must be assigned to the taught by at least 1 instructor. Information about students must also be stored, including unique student ID, name, and academic program. In addition, the numeric grade obtained by students enrolled in a course must be stored. The database system must also be able to convert the numeric grade into its corresponding grade letter. A student can be enrolled in many courses, or in none. Below is an incomplete version of a possible ERD for the presented mini world. Each incomplete element will be marked and denoted in the diagram with a red letter within parenthesis. Complete the ERD given following best practices learned in the course. Match each option letter shown on the ERD in red with the correct option shown in the question’s answers section. For example, if the question asks about the correct element shown in the ERD with the letter (A), you should select the option “name” in your answer from the options, indicating the instructor’s “name” attribute is the correct and missing element. Keep in mind there is only one correct matching value for each option. Question: What is the correct element shown in the ERD with the letter (L) ?

Read Details

A university registrar’s office is designing a database with…

A university registrar’s office is designing a database with the following characteristics: It is necessary to store information about courses and their corresponding unique course number, title, credits, and syllabus. Note that the prerequisite courses for any specific course (main course) is also needed to be known. Since not all existing courses may be offered to students to take, the database must store information about all courses offered and available, together with their year, semester, section number, room, and time. A specific course can be offered many times, or not at all. Logically, an offered course must match a single existing course.  The database must also store information about instructors, their unique IDs, names, departments, and titles. An instructor must teach at least one course, but no more than 7. Also, a course offered must be assigned to the taught by at least 1 instructor. Information about students must also be stored, including unique student ID, name, and academic program. In addition, the numeric grade obtained by students enrolled in a course must be stored. The database system must also be able to convert the numeric grade into its corresponding grade letter. A student can be enrolled in many courses, or in none. Below is an incomplete version of a possible ERD for the presented mini world. Each incomplete element will be marked and denoted in the diagram with a red letter within parenthesis. Complete the ERD given following best practices learned in the course. Match each option letter shown on the ERD in red with the correct option shown in the question’s answers section. For example, if the question asks about the correct element shown in the ERD with the letter (A), you should select the option “name” in your answer from the options, indicating the instructor’s “name” attribute is the correct and missing element. Keep in mind there is only one correct matching value for each option. Question: What is the correct element shown in the ERD with the letter (C) ?

Read Details

A university registrar’s office is designing a database with…

A university registrar’s office is designing a database with the following characteristics: It is necessary to store information about courses and their corresponding unique course number, title, credits, and syllabus. Note that the prerequisite courses for any specific course (main course) is also needed to be known. Since not all existing courses may be offered to students to take, the database must store information about all courses offered and available, together with their year, semester, section number, room, and time. A specific course can be offered many times, or not at all. Logically, an offered course must match a single existing course.  The database must also store information about instructors, their unique IDs, names, departments, and titles. An instructor must teach at least one course, but no more than 7. Also, a course offered must be assigned to the taught by at least 1 instructor. Information about students must also be stored, including unique student ID, name, and academic program. In addition, the numeric grade obtained by students enrolled in a course must be stored. The database system must also be able to convert the numeric grade into its corresponding grade letter. A student can be enrolled in many courses, or in none. Below is an incomplete version of a possible ERD for the presented mini world. Each incomplete element will be marked and denoted in the diagram with a red letter within parenthesis. Question: In the ERD above, the double lines connecting (D) with “IS OFFERED” denotes:

Read Details

Ducks are awesome animals.

Ducks are awesome animals.

Read Details

An organism that uses carbon dioxide for its carbon source i…

An organism that uses carbon dioxide for its carbon source is called a:

Read Details

When a cell builds a pilus, is this an anabolic reaction or…

When a cell builds a pilus, is this an anabolic reaction or a catabolic reaction?

Read Details

Which of the following terms describes an organism that uses…

Which of the following terms describes an organism that uses organic compounds for a carbon source?

Read Details

Match the relationship term to the description of the organi…

Match the relationship term to the description of the organism. Use each choice only once. (1 point each)

Read Details

On a nutrient agar, each _____________ represents a ________…

On a nutrient agar, each _____________ represents a ___________ from the sample population.

Read Details

A microaerophile:

A microaerophile:

Read Details

Posts pagination

Newer posts 1 … 26,508 26,509 26,510 26,511 26,512 … 60,203 Older posts

GradePack

  • Privacy Policy
  • Terms of Service
Top