Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An entity type that has no existence dependency is called strong entity. It can exist without depending upon the existence of another entity. The

An entity type that has no existence dependency is called strong entity. It can exist without depending upon Create a Script to create the 2 tables (one strong entity, and one with a weak entity). Also, create a log

An entity type that has no existence dependency is called strong entity. It can exist without depending upon the existence of another entity. The strong entity is also referred to as parent, or owner, or dominant. Case 2: Weak entities Thus, an instance of a weak entity cannot exist independently but depends on the existence of another entity (strong entity) instance. Design a database with two tables to demonstrate the difference between Strong entities and weak entities. (Do NOT use this EMPLOYEE & DEPENDENT example since Jim did this example in class) EMPLOYEE EmpNo Name DEPENDENT EmpNo Name ... Please DO NOT create this exact example, come up with your own example of a strong and weak entity. You are not permitted to turn in any example that I used in class. Many other samples will be provided in lecture. EMPLOYEE(EmpNo, Name, department, starting Year, benefits, ssn) DEPENDENT (EmpNo, Name, Birthdate, sex, ssn...) Page 1 of 2 Create a Script to create the 2 tables (one strong entity, and one with a weak entity). Also, create a log file "tee" when creating the database and inserting some test data. Create a UML diagram for this database or create an ER diagram for this PE. UML using Workbench is the best diagram. Attach the diagram to the assignment box. After some test data was inserted into the tables, select all the records from the weak relation (Dependent) and corresponding key in the strong table (Employee). Please do multiple Queries. LASTNAME.txt YOUR TEE FILE SHOULED BE NAMED Your TEE file should contain the following 3 Queries described below Attach tee files(MUST USE -verbose option) on every assignment. Queries that I want for Practice Exercise 09: 1) Query of all the records of the STRONG entity 2) Query of all the records of the WEAK entity 3) Query of selective data from BOTH the STRONG entity & WEAK entity a. Produce a MEANFULL report that contains data from both the b. Strong entity & Weak entity. c. This report must be LOGICAL, and display data that your boss might want to read every Friday. -- This query you are creating for your boss every Friday must e. -- be a PROJECTION of columns. Do not write SELECT * FROM ... 4) Use www.lucid.app create an ER diagram of your strong and weak tables. Covert your diagram to PDF and attach this PDF to the Assignment Box / Drop Box.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Based on the assignment you are asked to create a database with two tables where one represents a strong entity and the other represents a weak entity ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Smith and Roberson Business Law

Authors: Richard A. Mann, Barry S. Roberts

15th Edition

1285141903, 1285141903, 9781285141909, 978-0538473637

More Books

Students also viewed these Databases questions