HomeworkLib
Question

Q1: Each student has a unique student id, name, unique email address, and a phone number. A student is either a degree seeking student or a non-degree seeking student. For degree seeking students, additional information such as catalog year and date of admission are recorded. For non-degree seeking students, additional information on program of interest needs to be recorded. Only degree seeking students can submit financial aid applications. Each degree seeking student can submit multiple financial aid applications or none. However, each financial aid application is submitted by only one student. Create an ER Model to represent this scenario. Q2: A concert includes performance by one or multiple artists. Each artist can perform in none or multiple concerts. For each artist that performs in a concert, record if the artist participated as a guest appearance or as a main artist. Create an ER Model to represent this scenario

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

Homework Answers

Answer #1

Ans 1.student id student_nam email_id hone number STUDENT tudent i student i Tpursue (o,n) (0, n) NON-DEGREE DEGREE atalog yea inan

ANSWER 2.

artist id rtist name oncert name oncert i ARTIST CONCERT (o, n) pearance typ (0, N) GUEST OR MAIN ppearance concert i

0 0
Add a comment
Know the answer?
Add Answer to:
Q1: Each student has a unique student id, name, unique email address, and a phone number....
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

  • 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...

  • The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary,...

    The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will be to the same dentist. A client can be insured or self-paying. An insured client should have an insurance company-name, and company-Phone, while a self-paying client must have a bank-name and a bank account....

  • system analysis and design Class Diagram Scenario An instructor consists of name, address, email, number, and...

    system analysis and design Class Diagram Scenario An instructor consists of name, address, email, number, and salary. There can be either a full-time or part-time instructor. A student consists of name, student number, and email. Students can enroll for at least one seminar in a semester. Each seminar consists of seminar name, seminar number, and fees. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Only two...

  • Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security...

    Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student&#39;s permanent address, and to the student&#39;s last name. Both social security number and student number have...

  • Fly-By-Night University (FBNU) has several campuses and has recently decided to centralize their student records. The...

    Fly-By-Night University (FBNU) has several campuses and has recently decided to centralize their student records. The university’s main office needs to develop a new system to house student records and course information. You have been hired to make recommendations regarding the design of the new system. You have met with key personnel for the purposes of requirements gathering. You have analyzed the current system and the goal for the future system. These are the items you have determined: Faculty are...

  • Instructions Fly-By-Night University (FBNU) has several campuses and has recently decided to centralize their student records....

    Instructions Fly-By-Night University (FBNU) has several campuses and has recently decided to centralize their student records. The university’s main office needs to develop a new system to house student records and course information. You have been hired to make recommendations regarding the design of the new system. You have met with key personnel for the purposes of requirements gathering. You have analyzed the current system and the goal for the future system. These are the items you have determined: Faculty...

  • 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...

  • You have been approached by a University for the design and implementation of a relational databa...

    You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database design process provided the following data requirements for the University Database system. Using the following requirements answer this...

  • DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed Apr...

    DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...

  • Lab Assignment Each student has been assigned a unique data set, and will be required to perform ...

    having trouble working excel, please help Lab Assignment Each student has been assigned a unique data set, and will be required to perform basic statistical analyses on the data. Each exercise should be saved to a new file so one of your first tasks will be to make sufficient copies of your data file, named appropriately. E.g. Grant, Karen Inf Stats Ex1; Grant, Karen Inf Stats Ex2; Grant, Karen Inf Stats Ex3. All data files are taken from real data...

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