so I have an EER diagram ( picture below ) and I need to make it as tables and Use appropriate naming conventions for all of your tables and attributes Last_nameFirst nameNameCodeChairmanCollegeInstructor idNameEmailBelongtoDepartmentHasInstructorOfficeMajorMajor_nameMajor inMajor_codeMajor_unitIDGrade1AddresStudentNRegisterInstructnameSemesterSec noYeardep_codeFirstGPAMEX_dateInstroctor_nameLastEX_timeDropSectionMHasCoursecreditRoomNameMax_sizeCurr_sizedaysTime_fromTime totitle

The question has been answered in step2

Answered: so I have an EER diagram ( picture…

so I have an EER diagram ( picture below ) and I need to make it as tables and Use appropriate naming conventions for all of your tables and attributes

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: the Garden Glory database and Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the…

Q: Why do you think entity relationship (ER) diagrams in database design are necessary?

A: Entity Relationship Diagram is a conceptual, graphical, and logical structure of a database. Entity…

Q: Describe a feature that is found in Design View but not in the Datasheet View. Describe two…

A: Datasheet view:It shows the data in the database and allows user to enter and edit the data.Here…

Q: Consider the following E-R diagram: E1 RI E2 R4 R2 R5 EA R3 E3 What is the minimum number of…

A: Introduction Given, An ER diagram . We have to calculate the minimum number of relation required…

Q: utput restaurant relationship diagram / restaurant adjacency

A: It is defined as a Entity Relationship Diagram type of flowchart that illustrates how “entities”…

Q: Write down the all views of 4+1 View Model with the purpose, stakeholders and way of representation…

A: all views of 4+1 View Model The Logical Architecture:The Object-Oriented DecompositionObject…

Q: When doing away with rows, columns, and tables, what is the most critical consideration to bear in…

A: It emphasizes the importance of presenting data in a clear and meaningful way by considering the…

Q: It is essential to discuss the various database table possibilities when dealing with subtype…

A: A Contacts table in a company database may store suppliers' names, e-mail addresses, and phone…

Q: There are no direct connections allowed between external entities and the database. It's one of the…

A: Given: A Data Flow Diagram (DFD) depicts the flow of data across a cycle or framework. DFDs help you…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Q: Why are some table structures deemed terrible while others are deemed good? How can you know which…

A: Given that; The topic is about Why are some table structures deemed terrible while others are deemed…

Q: 13 of 40 Consider the following E/R diagram with isa relationships, noting that attribute a is the…

A: The correct relation for given ER diagram is ST(a,b,c,d)

Q: It is essential to discuss the various database table possibilities when dealing with subtype…

A: A company's Contacts table may store supplier names, e-mails, and phone numbers. Because other…

Q: Indicate the changes (using the shorthand representation) that you would need to make to the…

A: Question 1.) Indicate the changes (using the shorthand representation) that you would need to make…

Q: 5.6 LAB - Implement independent entity (Sakila) Implement a new independent entity phone in the…

A: First check whether phone_id column exists in your customer, staff, and store table or not. If…

Question

so I have an EER diagram ( picture below ) and I need to make it as tables and Use appropriate naming conventions for all of your tables and attributes

Last_name
First name
Name
Code
Chairman
College
Instructor id
Name
Email
Belong
to
Department
Has
Instructor
Office
Major
Major_name
Major in
Major_code
Major_unit
ID
Grade
1
Addres
Student
N
Register
Instruct
name
Semester
Sec no
Year
dep_code
First
GPA
M
EX_date
Instroctor_name
Last
EX_time
Drop
Section
M
Has
Course
credit
Room
Name
Max_size
Curr_size
days
Time_from
Time to
title

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Discuss database table possibilities for creating subtype relationships. Discuss the considerations that might lead you to choose one design over the others.
Please follow this ER diagram, give a description, and make a schema diagram from it. Also, make database (constraint tables) & intent some sample data. Lastly, run some SQL functions code. Please don't copy from anywhere. I need it for my project.
can you provide me with details on the progression from 1NF to 3NF form with the relation between the tables along with the EER design? thank you
Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio's crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables. Requirements: Show the results of the normalization as individual tables Show the FK and PK columns using Visio's notation You must solve the multi-column issue with grades (Hint: This will require a new column) Show the 3-part column definition as noted Show min/max cardinality Tables are attached
Please provide a list and illustrative example for the three forms of binary relationships that are not covered in this book. Draw a regular E-R diagram as well as an IE Crow's Foot E-R diagram for each of the three cases studied here.
Draw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different…
Discuss your database table possibilities for creating subtype relationships.Talk about what you would look for in a design and how it would affect your final selection.
Instructions: In this assignment, you will convert an Entity-Relationship diagram into a set of related tables. Given the following ERD, write the table definitions for the entities displayed below. You do not have to indicate data types nor “not null” constraints in this lab. Use the format TableName ( attribute, attribute…attribute). Designate primary keys with an underline and foreign keys with a broken underline. To illustrate, the Regions and Countries table definitions have been created for you below the diagram. Type your answers in this document and upload it to the appropriate Blackboard assignment link by Monday at 11:59 p.m. ET of this module/week. Note that you should read the “Table Conversions Explained” document in your Reading & Study folder. I created it to help you better understand how ERDs will ultimately be transformed into real tables. ERD for the Hourglass timekeeping database
Please provide a list and illustrative example for the three forms of binary relationships that are not covered in this book. Draw a regular E-R diagram as well as an IE Crow's Foot E-R diagram for each of the three cases studied here.
E-R diagrams or DBDL may show database structure. Why do you prefer this method?
Murach's SQL Server 2019 for Developers Create an Entity Relationship diagram using Visio or visual-paradigm or Lucidchart or other sources. You will look at page 313 of your textbook and recreate the middle example that includes the Employees, Membership, and Committees tables.
Your task is to break this up into a list of "normalized" tables that you describe using the text-based "relational notation". You will need to break this example into as many separate tables as you feel is appropriate to remove all modification anomalies. Please submit your relational notations in an ordinary word document along with the sample data in a "grid". I'm expecting to see both PK and FK notations in your submission. Note: I'm not asking for a database... I'm asking for a list of tables in relational notation plus the sample data in rows/columns. Part One: Use text-based relational notation to describe each table/field Note: I am not yet requiring you to solve the "multi-column" problem Show PK and FK (use Microsoft Word's underline and italics tools) Part Two: Create a "grid" for each table with the all of the rows/columns of data for that table after normalization (to include PKs/FKs) Make sure you don't have any duplicate rows in your "grid" Note: You can just do…