An entity type that has no existence dependency is called strong entity. It can exist without...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
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 ... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these databases questions
-
Problem 3: Let P' (mass 4 m) be an attracting particle acting on the system S. The system S is comprised of the 4 colored particles: S4 a2 S1 S3 S2 Then, the system S possesses the following...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
How much taxes do Employees and Employers pay in F.I.C.A? a) Employees and Employers paid 1.45% in taxes. b) Employees and Employers paid 7.65% in taxes. c) Employers and Employees paid 2.7% in...
-
Describe three of the main barriers to adoption of e-commerce by consumers and suggest how a company could counter these.
-
Why would a company choose to introduce a low-price, fighter brand? Provide an example. What should the company be wary of when it launches a low-price fighter brand?
-
How many corn plants are too many? How much corn per acre should a farmer plant to obtain the highest yield? To find the best planting rate, do an experiment: plant at different rates on several...
-
ABCD Company is a general partnership. It consists of Dianne, Greg, Knox, and Laura, whose capital contributions were as follows: Dianne = $5,000, Greg = $7,500, Knox = $10,000, and Laura = $5,000....
-
M13-1 (Algo) Calculations for Horizontal Analyses [LO 13-2] Using the following income statements, perform the calculations needed for horizontal analyses. (Decreases should be indicoted by a minus...
-
Thunder Attractions, an amusement park, is considering a capital investment in a new exhibit. The exhibit would cost 136,000 and have an estimated useful life of 5 years. It will be sold for 60,000...
-
You work for a nuclear research laboratory that is contemplating leasing a diagnostic scanner (leasing is a very common practice with expensive, high-tech equipment). The scanner costs $5,000,000,...
-
Part 2 One Stop Electrical Shop are merchandisers of household fixtures & fittings. The business began the last quarter of 2020 (October to December) with 25 Starburst Wall Clocks at a total cost of...
-
A species of butterfly has three subspecies A, B, and C. A scientist is trying to classify observed. specimens into these subspecies based on the color of their wings, which can be blue, green, pink,...
-
Stock during the year were sold for $8 per share. On December 31 , Portland had no remaining treasury stock. Required: Prepare the necessary journal entries to record any transactions associated with...
-
2) 20 pts. A 2-kg block rests on a wedge that has a coefficient of friction between the wedge and block of 0.3. The system accelerated to the right. Determine the maximum acceleration of the system...
-
ABC Ltd. is concerning about its poor performance and considering whether or not dropping the production and sells of product R, which incurs losses of Birr 4000. Additional information: The salaries...
-
Comparing three depreciation methods Year 1 , 4 , 3 2 0 hours in Year 2 , and 4 , 3 2 0 hours in Year 3 . Required: the 3 years by each method. Do not round intermediate calculations when determining...
-
A company has the following incomplete production budget data for the first quarter: In the previous December, ending inventory was 200 units, which was the minimum required, at 10% of projected...
-
Identify the principal attributes and classifications of a corporation.
-
Grant leased an apartment to Epstein for the term May 1, 2010, to April 30, 2011, at $750 a month payable in advance on the first day of each and every month of said term. At the time the lease was...
-
Explain the legal restrictions imposed upon dividends and other distributions.
-
33. On January 1,2008, a rich citizen of the Town of Ristoni donates a painting valued at $300,000 to be displayed to the public in a government building. Although this painting meets the three...
-
31. The City of Lawrence opens a solid waste landfill in 2008 that is at 54 percent of capacity on December 31, 2008. The city had initially anticipated closure costs of $2 million but later that...
-
29. On January 1, 2008, the City ofVerga leased a large truck for five years and made the initial annual payment of $22,000 immediately. The present value of these payments based on an 8 percent...
Study smarter with the SolutionInn App