HomeworkLib
Question

I need to draw an ER diagram for a future database necessary to hold application data...

I need to draw an ER diagram for a future database necessary to hold application data for students wishing to apply for a programming internship job on campus.

The students will provide the following information on the application:

studentID_Number, first name, last name, email, phone number, address, city, state, postal code, major, currently enrolled in school?, expected date of graduation, web framework of choice, list of programming languages in which the student is proficient, SAT score, ACT score, GPA, 4 character references, list of previous employments

Some people wishing to apply might not be students and will not have a studentID_Number which important when deciding on appropriate primary keys.

Please draw an ER diagram that will represent how a future database should store the students' data provided above.

Thanks in advance for the help.

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

Homework Answers

Answer #1

Solution:

Entities for ER Diagram for Candidates Database for Internships of a Tech Company

.1. External Candidate

2. Student

3.Tech Company

4 Application

5.Internship

6 H R Department(Manager)

Attributes shown in Diagram,

ER diagram is as shown below:

0 0
Add a comment
Know the answer?
Add Answer to:
I need to draw an ER diagram for a future database necessary to hold application data...
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

  • Need help with database ER diagram. Thank you Design a database for team sport of your...

    Need help with database ER diagram. Thank you Design a database for team sport of your choice (for example hockey, soccer). Include information about athletes and their team. Draw the ER diagram. Be sure to underline the Primary keys. -ATHLETE includes their name, age, id, -TEAM includes name, id, colors, city, ranking -Each athlete PLAYS_FOR a team and what year they started

  • DATABASE Draw an ER diagram according to the following requirements.   The bank application keeps track of...

    DATABASE Draw an ER diagram according to the following requirements.   The bank application keeps track of the following information. As a customer of the bank, he/she must either own an account or borrow a loan. The banking application does not require a customer to both own account and borrow a loan. Customer information includes a SSN (unique), a name, and an address. A customer can borrow at most one loan. A loan has a loan number (unique) and an amount....

  • Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to p

    Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to produce the results.Figure 7-16: Class scheduling relations (for Problems and Exercises 1-5Figure 7-17 Adult literacy program (for Problems and Exercises 6-14)1. Write SQL retrieval commands for each of the following queries:a....

  • Question: Draw the ER diagram of your database design in Crow’s Foot notation. RULES OF DATABASE...

    Question: Draw the ER diagram of your database design in Crow’s Foot notation. RULES OF DATABASE Each thesis has the following mandatory attributes: thesis no (numeric), title, abstract, author, year, type (one of Master, Doctorate, Specialization in Medicine, and Proficiency in Art), university, institute, number of pages, language (Turkish, English, etc.), and submission date, A person can be author of more than one theses (for example, a person can prepare a Master thesis, later s/he can prepare a Doctorate thesis),...

  • Describe briefly a database application case of your choice and represent your data in terms of...

    Describe briefly a database application case of your choice and represent your data in terms of 3 linked (via foreign key/s) tables. List their respective primary key and foreign key/s if any. Your database application case should be different from those already covered in the lectures or practicals. For the database case in the Additional Exercises of the previous practical, complete the proper construction of all the 5 tables in SQL, building all the pertinent primary and foreign keys there....

  • Database 1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following...

    Database 1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affil- iated only with one DEPARTMENT; A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT; on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. (15 points) A trucking company is...

  • Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to...

    Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to create the model. The correct syntax must be used. Remember to list out all alternate keys, secondary keys, and foreign keys. Entity Relationship Diagram (ERD) Draw the data model for the situation using LucidChart, Microsoft Visio, Word or other ERD Drawing Program. When drawing the objects, be sure to use the correct shapes, and syntax. Example: Entity is a rectangle box, and the name...

  • Would you please help me with this homework ? 1- Explain what requirements this ER diagram...

    Would you please help me with this homework ? 1- Explain what requirements this ER diagram is implementing 2- Draw an ER diagram (relationships) for the following business rules in a company: • A salesperson manages one or many other salespeople while a salesperson is managed by only one salespeople. • A salesperson can be an agent for many customers but a customer is managed by only one salesperson. • A customer can place many orders. But an order can...

  • Part. II Please draw ER Diagram and write relational data model for the following business. 1....

    Part. II Please draw ER Diagram and write relational data model for the following business. 1. IT Training IT Specialists is a company to provide IT courses in programming, database development and Web applications. Business rules include: » Each course is identified by a unique course number (cNo) and other course attributes include: course name (cName), course description, pre-requirements . At least one and up to many sections can be offered by each course. » Each section is identified by...

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