Question

In: Computer Science

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.

Solutions

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:


Related Solutions

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
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 find 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...
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.
Assume you are creating a database for IS paint store. The database needs to support the...
Assume you are creating a database for IS paint store. The database needs to support the following business functions. • Allow customers to browse the inventory. Customers want to search by paint types and colors. Customers also wants to know pricing information. • A customer can be a regular customer (e.g., home owner), or a contractor or painting professionals. Different customers can get different discounts for the same type of paint. We assume each customer can get the same discount...
True or False: Logical database design is the process of modifying the physical database design to...
True or False: Logical database design is the process of modifying the physical database design to improve performance. The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization. Multivalued attributes are not permitted in unnormalized data. A many-to-many binary relationship in an E-R diagram requires the creation of a total of three tables in a relational database. A one-to-one unary relationship in an E-R diagram requires the creation of a total of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT