Develop a Entity-Relationship Diagram (ERD) Many-to-Many The city of Terra Haute, IN wants to maintain information...

Develop a Entity-Relationship Diagram (ERD)

Many-to-Many

The city of Terra Haute, IN wants to maintain information about its extensive system of high schools, including its teachers and their university degrees, its students, administrators, and the subjects that it teaches.

Each school has a unique name, plus an address, telephone number, year built, and size in square feet. Students have a student number, name, home address, home telephone number, current grade, and age. Regarding a student’s school assignment, the school system is only interested in keeping track of which school a student currently attends. Each school has several administrators, such as the principal and assistant principals. Administrators are identified by an employee number and also have a name, telephone number, and office number.

Teachers are also identified by an employee number and each has a name, age, subject specialty such as English (assume only one per teacher), and the year that they entered the school system. Teachers tend to periodically move from school to school and the school system wants to keep track of the history of which schools the teacher has taught in, including the current school. Included will be the year in which the teacher entered the school and the highest pay rate that the teacher attained at the school. The school system wants to keep track of the universities that each teacher attended, including the degrees earned and the years in which they were earned. The school system wants to record each university’s name, address, year founded, and Internet URL (address.) Some teachers, as department heads, supervise other teachers. The school system wants to keep track of these supervisory relationships but only for teachers’ current supervisors.

The school system also wants to keep track of the subjects that it offers (e.g. French I, Algebra III, etc). Each subject has a unique subject number, a subject name, the grade level in which it is normally taught, and the year in which it was introduced in the school system. The school system wants to keep track of which teacher taught which student which subject, including the year this happened and the grade received.

Expert Solution

venereology answered 1 year ago

Use information from text to create (ERD) Entity Relationship Diagram . Make sure relationship sentences are...

Use information from text to create (ERD) Entity Relationship Diagram . Make sure relationship sentences are consistent with relationship in ERD. Video Store (AVS) runs a series of fairly standard video stores: • Every customer must have a valid AVS customer card in order to rent a video. Customers rent videos for three days at a time. Every time a cus- tomer rents a video, the system must ensure that he or she does not have any overdue videos. If...

2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is...

2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes researcher name, title, position; university name, location, enrollment; and research interests. Each researcher is associated with only one institution, and each researcher has several research interests. 3. Visit a Web site that allows customers to order a product over the Web (e.g., Amazon.com). Create a data model that the site...

Create an Entity relationship diagram (ERD) conceptual model for this case. VINEYARD HOLDINGS AND GRAPE VARIETIES...

Create an Entity relationship diagram (ERD) conceptual model for this case. VINEYARD HOLDINGS AND GRAPE VARIETIES VVI’s vineyard sources its wine from ten plots of land in separate locations from two acres to twenty acres. Each vineyard has its own unique name, such as Rattlesnake Canyon, Red Fox, Theresa’s, etc. and is either owned by VVI or by an independent third party. Each is managed by a single employee. No employee manages more than one vineyard. The location and size,...

case study 1. Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify...

case study 1. Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify correct relationships, attributes, and identifiers (keys). 2. Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+). case: HELP is a voluntary organization that provides aid to people. Based on the following brief description of operations, create the appropriate fully labeled Crow’s Foot ERD. Individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their...

Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent...

Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent the information requirements of company you are working for. You also need to write business rules and assumptions. Task 2: Create the Data Dictionary base on your ERD diagram.

Research and explain with your own words Chen’s entity-relationship data (ERD) model and the process of...

Research and explain with your own words Chen’s entity-relationship data (ERD) model and the process of normalization from first normal form to third normal form. Discuss what types of information are stored in your sector (or sector of interest) and what types of information are shared with a third party (if any).

Designing and refining an Entity-Relationship Model A company wants a simple database to record information about...

Designing and refining an Entity-Relationship Model A company wants a simple database to record information about ticket sale for theatre performances. They describe the key elements of their requirements in the following points: • Customers have a name, phone number, a credit card no, and a unique customer number. • Customers can attend many performances, and each performance can have many customers attending. • Each performance of a show is on at a specific date and time, at a venue....

In this project you will be provided a set of specifications to create an entity-relationship diagram...

In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the attributes for the entities will be identified and described. This database will provide the foundation for the follow-on project. The following paragraphs provide the background and summary of the business requirements. You are a database consultant with Premier Software, LLC and have been assigned to...

business rules and entity-relationship diagram insurance, invoice, patient, appointment, employee

A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that...

A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that captures, as far as possible, the requirements stated below. (Statements in brackets are additional explanations and not part of the requirements proper.) If you make any assumptions in your design, please write them down. Assumptions, however, must not contradict the requirements. 1. The supermarket sells products. Each product is uniquely identified by its product number. Moreover, a product has price. The supermarket also records...

Question