Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw...

Creating a Database Design

Lab 1: Creating a Database Design (Wk 3) - OR - Draw with pencil and paper diagram (take photo of it and submit) along with a summary of the diagram you prepared in a Word document.

Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab:

Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.

Expert Solution

The following relationship diagram may be created based on the information provided in the question for the college requirements. It is a limited one and contains only those entities mentioned in the resquirement.In the diagram, each student can take one or more courses he wishes to. Each course is taught by a teacher(instructor). Again, a teacher can teach more than one courses and we have a foreign key constraint of the course_id with both the student and the teacher table. Each student gives various exams during his semester but one student can appear in an exam for once only. The exam_name is the primary key in the exam table. All the other primary keys are also underlined in the diagram.

Diagram:

venereology answered 2 years ago

Need answers for Normalization, Physical Design, Sql, And Security exam. 1. The database you're creating will...

Need answers for Normalization, Physical Design, Sql, And Security exam. 1. The database you're creating will be installed on a group of three servers. What feature of an enterprise RDBMS will allow one server to pick up the processing work if the main server becomes nonoperational? A. Failover B. Business intelligence C. Data warehouse D. Load balancing 2. What type of clause must you always use with DELETE or UPDATE to avoid inadvertently changing data elsewhere in the database? A....

WK-3-A-1 Job Description, Analysis, and Design and Mutual Respect and Trust The knowledge of jobs is...

WK-3-A-1 Job Description, Analysis, and Design and Mutual Respect and Trust The knowledge of jobs is used for many purposes, certainly in the field of HRM for healthcare organizations. In particular, knowledge of what a job requires an employee to do—the basis for pay—is essential to make comparisons with other jobs for market pricing and as the first step in evaluating jobs internally. Today and every day, as leaders or managers, we want to emphasize the golden rule of treating...

PLEASE ANSWER ASAP 1- The major tool used to draw/construct a logical database design is the...

PLEASE ANSWER ASAP 1- The major tool used to draw/construct a logical database design is the _______________. 2- The ID field is planned to be the primary key field in the below diagram. No fields are required to be filled/entered. ID Equipment Type Equipment Number Daily Rate phone no 1 Back Hoe 10400 $750.00 diesel powered 1 Medium Crane 335 $350.00 plus tax 3 Back Hoe 10020 $650.00 (631) 992-4567 (516) 429-0800 3 Scaffolding 5 Foundation 335 $0.00 11/17/1952 ...

Lab 1 – Databases, Schemas, and Basic Tables For this lab we will be creating a...

Lab 1 – Databases, Schemas, and Basic Tables For this lab we will be creating a small Student Loan Database. Make sure to open your screenshot word document. Include the required screenshots of your code in the document. Database: Create a new database: StudentLoan_LastName. Schemas: Create the following schemas. Make sure to screenshot and run your code: 1. Student 2. Guarantor 3. Institution 4. Activity 5. Loan 6. Lender Tables: First complete the word document for designing the tables like...

Database ____ which is the logical design of the database, and the database _ which is...

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time. a) Instance, Schema b) Relation, Schema c) Relation, Domain d) Schema, Instance

Database Management Systems Question a. Design a simple RETAIL store records database with 3 to 4...

Database Management Systems Question a. Design a simple RETAIL store records database with 3 to 4 tables to track customer purchases of store products and answer the following questions about your database. b. Create an instance (a state) of your database.

1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to...

1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to identify primary keys, relationship cardinalities, etc. State any assumptions you make. 1b. Convert your E-R diagram to the relational schema. Identify the primary keys of ever relation. Consider the following application: An electronics vendor operates both a Web site and a chain of many physical stores. Examples include Best Buy and Circuit City. To ﬁnd out more about this application, think about any experiences...

Draw a complete ERD of a database design to meet their needs First Urban Rescue (FUR...

Draw a complete ERD of a database design to meet their needs First Urban Rescue (FUR ) takes in cats and dogs that are no longer wanted in their old home , and tries to find them new homes . For each pet taken in by FUR , the pet is given a name if it doesn't already have one . The breed , name , approximate age , height , weight , and date arrived at FUR is recorded...

Draw an ER diagram and write a database design outline for the following prompt: You run...

Draw an ER diagram and write a database design outline for the following prompt: You run a coaching service to help high school students prepare for the SAT exam. You have a staff of coaches, each of which has an employee ID, an hourly rate (such as $20 per hour), and personal information consisting of their first name, last name, middle name/initial, address information, phone number, mobile phone number, and e-mail address. For each high school student, you want to...

our company is creating the database for the sales system. These are the major components: Database...

our company is creating the database for the sales system. These are the major components: Database design User entry form design Report design Access and authentication Maintenance You are assigned as an IT manager. For this Discussion, gather information from the library and research other web resources. Write a plan describing your role in designing, developing, managing, and supporting the database.

Question