Question: SQL need help to finish my data dictionary for format and range (section highlighted that it blank). Also if there is anything i didn't do

SQL need help to finish SQL need help to finish my data dictionary for format and range my data dictionary for format and range (section highlighted that it blank). Also if there is anything i didn't do properly.

Table Name Attribute Name Contents Type Range RequiredPK/FK FK Ref Table Format Company info Stock_id Stock identification Name of Stock (Amazon) Stock ticker (AMZN, MSFT) Stock Exchnage (NYSE) Industry of Company Sector of Company BIGINT VARCHAR(80) CHAR (5) VARCHAR(80) VARCHAR(80) VARCHAR(80) PK Stock name Stock ticker Stock_exchange Industry Sector FK Stock data Stock data stock id Date Volume Current Price Stock ticker Open_price Close_price Today high Today_low Stock indentification Today's Date Stock Volume Exact Price of stock right now DECIMAL(18,4) Stock ticker (AMZN, MSFT) CHAR (5) Stock open price Stock close price Today's high Today's Low BIGINT Date DECIMAL (18,4) FK DECIMAL(18,4) DECIMAL(18,4) DECIMAL (18,4) DECIMAL (18,4) Table Name Attribute Name Contents Type Range RequiredPK/FK FK Ref Table Format Company info Stock_id Stock identification Name of Stock (Amazon) Stock ticker (AMZN, MSFT) Stock Exchnage (NYSE) Industry of Company Sector of Company BIGINT VARCHAR(80) CHAR (5) VARCHAR(80) VARCHAR(80) VARCHAR(80) PK Stock name Stock ticker Stock_exchange Industry Sector FK Stock data Stock data stock id Date Volume Current Price Stock ticker Open_price Close_price Today high Today_low Stock indentification Today's Date Stock Volume Exact Price of stock right now DECIMAL(18,4) Stock ticker (AMZN, MSFT) CHAR (5) Stock open price Stock close price Today's high Today's Low BIGINT Date DECIMAL (18,4) FK DECIMAL(18,4) DECIMAL(18,4) DECIMAL (18,4) DECIMAL (18,4)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Hello. I'm a little lost with this. Supposed to be creating a database for a gourmet store. This is what I have in my data dictionary so far: this is an example of the data dictionary: blank sheets...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Can someone please help me implent the java coding section. I only get the building view part of the xml layout. I need help with the Mortgage Data section , Exception Handling section, Voice output...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Excel Project 1 - MS Excel (Spring 2020) Use the following project description to complete this activity (all the details are included in this document, in the 22 steps below) For a review of the...

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

TASK 1: MAKE UPDATES AND CORRECTIONS Based on Part 1 Comments-20 Points: 1. Update the data model: Make any required changes to your design based on the comments provided for Part 1 of the project....

Case Study: KALCH Distribution Company (KDC) Overview KDC is a regional transportation and distribution company in operation for over 60 years. The company serves major cities in the Mid-Atlantic...

In the context of online marketing communications, briefly explain what viral marketing is. Is it a worth-while pursuit for marketing organizations?

In 2011, the mean property crime rate (per 100,000 people) for the 11 western states was about 3331; the standard deviation was 729. Assume the distribution of crime rates is unimodal and symmetric....

Lab - Use Ping and Traceroute to Test Network Connectivity Topology Addressing Table Device Interface IP Address / Prefix Default Gateway R 1 G 0 / 0 / 0 6 4 . 1 0 0 . 0 . 2 / 3 0 N / A 2 0 0 1 :db 8...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Question What kinds of organizations can adopt Section 401(k) plans?

Question Can employees make contributions to a profit sharing plan?

Question Suppose an employer can afford to make substantial contributions to a defined benefit plan. Can a plan be designed with a very low actuarial interest assumptions so that the annual...