HomeworkLib
Question

(identify the BEST choice of primary key in the table) A CSUS student academic record consists...

(identify the BEST choice of primary key in the table)

A CSUS student academic record consists of: student ID, student name, Course registered (e.g. CIS2000), semester registered (e.g. F02. the table may contain records from different semesters), and grade (e.g. I for Incomplete). A student might register for the same course more than once in order to improve grade (e.g. a student got a D for CIS2000 in fall 2019; s/he might register CIS2000 again during spring 2020 in order to get a better grade). A student might have registered for many different courses in the same semester.

RECORD (STU_ID, LNAME, FNAME, COURSE, SEMESTER, GRADE)

A.

STU_ID + COURSE
B.

STU_ID
C.

STU_ID + COURSE + SEMESTER
D.

STU_ID + COURSE + SEMESTER + GRADE
E.

STU_ID + SEMESTER
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

the * 1 in table.- To identify the best choice of primary key in the on this the student academic recold conkin Student ID, S

0 0
Add a comment
Know the answer?
Add Answer to:
(identify the BEST choice of primary key in the table) A CSUS student academic record consists...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Writing 3 Java Classes for Student registration /** * A class which maintains basic information about...

    Writing 3 Java Classes for Student registration /** * A class which maintains basic information about an academic course. */ public class Course {    /** * Attributes. */ private String code; private String title; private String dept; // name of department offering the course private int credits; /** * Constructor. */ public Course(String code, String title, int credits) { // TODO : initialize instance variables, use the static method defined in // Registrar to initialize the dept name variable...

  • Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary...

    Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary keys & foreign keys. Please include drop table statements with cascade constraints before your create table statements so it is easier to grade your create table statements. E.g., suppose you will create table tab1, tab2, including the following before creating them: Drop table tab1 cascade constraints; Drop table tab2 cascade constraints; Assumptions: Each teacher can teach one or more scheduled course sections. Each scheduled...

  • "SEU Examinations System(SES),"automation of the examination activities of SEU that aims to bring in a centralized...

    "SEU Examinations System(SES),"automation of the examination activities of SEU that aims to bring in a centralized system that will ensure the operations in the context of an examination that can manage effectively. This system allows students to register the courses every semester themselves into the system by providing the details or by sharing details to admin at each branch. If the student is doing it by their own, then the system should check the login credentials and then the user...

  • Create an ER Diagram showing all entities and relationships that describe the scenario below: You are...

    Create an ER Diagram showing all entities and relationships that describe the scenario 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: 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...

  • python anywhere questions. A Class Management System, Part 2 Please also refer to the description provided...

    python anywhere questions. A Class Management System, Part 2 Please also refer to the description provided in Part 1 of the project “A Class management System”. You have had a chance to state your understanding of the requirements for this project, draft a preliminary design, and express it by means of UML diagrams. Now it’s time to implement your design. As stated in the original requirements, there will be three categories of users: 1. Students 2. Instructors 3. Administrators Recall...

  • plz No handwriting and NO pictures Introduction The case study is about the analysis of the...

    plz No handwriting and NO pictures Introduction The case study is about the analysis of the students’ understanding in analyzing a given scenario and practical skills to apply concepts and build diagrams studied in IT242 (Software Engineering). The case study consists of five parts. Students are required to answer all these parts based on the below scenario. The SEU has adopted a blending approach to electronic learning, requiring learners to attend class lectures (25%), while 75% of course time is...

  • The case study is about the analysis of the students’ understanding in analyzing a given scenario...

    The case study is about the analysis of the students’ understanding in analyzing a given scenario and practical skills to apply concepts and build diagrams studied in IT242 (Software Engineering). The case study consists of five parts. Students are required to answer all these parts based on the below scenario. The SEU has adopted a blending approach to electronic learning, requiring learners to attend class lectures (25%), while 75% of course time is assigned to virtual classes, learning forums and...

  • Name Use complete sentences if possible The following StudentGrade relation (table) stores the Student, Major, and Course information Each student has unique StudentID. Assume that a student has...

    Name Use complete sentences if possible The following StudentGrade relation (table) stores the Student, Major, and Course information Each student has unique StudentID. Assume that a student has only one major. One student can take multiple courses in one SemesterYear. One course can be taken by many students in each SemesterYear. Given values for StudentID, Course Number, and SemesterYear, one can determine all the rest of values for a record. However only Grade is functionally dependent on StudentlD, CourseNumber and...

  • Problem Specification: Write a C++ program to calculate student’s GPA for the semester in your class. For each student, the program should accept a student’s name, ID number and the number of courses...

    Problem Specification:Write a C++ program to calculate student’s GPA for the semester in your class. For each student,the program should accept a student’s name, ID number and the number of courses he/she istaking, then for each course the following data is needed the course number a string e.g. BU 101 course credits “an integer” grade received for the course “a character”.The program should display each student’s information and their courses information. It shouldalso display the GPA for the semester. The...

  • This is database system concept. 1.Find the ids of instructors who are also students using a...

    This is database system concept. 1.Find the ids of instructors who are also students using a set operation. Assume that a person is identified by her or his id. So, if the same id appears in both instructor and student, then that person is both an instructor and a student. Remember: set operation means union, intersect or set difference. 2.Find the ids of instructors who are also students using the set membership operator. 3.Find the ids of instructors who are...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT