Write a definition Description for the three tables below The definition must define the noun, which constitutes one record in the table The three tables below will have descriptions for both the tables and all attributes in those tables implemented in their description properties Each table description should be written to define the noun which constitutes one record in the table The description should be written as if preceded by the phrase, One record in this table represents Examples Customers A person or organization who has purchased products from us in the current or past three fiscal years Excludes prospective customers listed in the Prospects table and old customers archived in the Customers table in the SalesArchive database Sale A temporary purchase price discount offered on selected products (listed in the SaleProducts table) during the period defined by the SaleStartDate and SaleEndDate attributes 1 The definition must define the noun, which constitutes one record in the table 2 The definition must define the noun, which constitutes one record in the table 3 The definition must define the noun, which constitutes one record in the table QLQueryl OWNER PC 1385nXSahLmrfk Owner PCMONner (53) Microsoft SQL Server Mand gement Studio PC Kvu File Edit View Query Project Debug Tools Window Help Debug SQL Queryl sql CIOwl dbol Sect PC (SQL Server 1106020 Databases System Databases snapshots EE U CAKS2017D8 Kwu4385nXSahl E Database Diagrams Tables System Tables ileT bo,CECo H dbo CEProvid Results G bo,Instruct Type Created datetme dbo Professia Section 2017 02 23 22 23 00 270 dbo,Qualifi Column Type Computed Length Frec Scale Nullable Tim Trail dbo QualificationTyp bo,Secti 10 no fCECou El Views Section Number Programmability El varchar no Service Broker Hoom Number Storage ldentty Seed increment Not For Repleation Security Report Serv Query executed successfully Ready Collation NULL SQL Latin General CP1 CLAS sal Latin1 Ganeral CP1 CLAS (m al OWNER PC 1 0 SP3) Onne 00 00 00 Cument connection parameters Elapsed time 00 0000292 3 25 2017 838 01 AM 38 01 AM OWN R PC (O aps 00 0000 23 38 01 AM Connection rows 13 start 3 25 20 838 01 AM OWNER PC Server version Session T Col16 Ch 16 8 58 AM

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 25, 2024

Write a definition Description for the three tables below. The definition must define the noun, which constitutes one record in the table. The three tables

Write a definition Description for the three tables below. The definition must define the noun, which constitutes one record in the table. The three tables below will have descriptions for both the tables and all attributes in those tables implemented in their description properties.

Each table description should be written to define the noun which constitutes one record in the table. The description should be written as if preceded by the phrase, "[One record in this table represents...]" Examples:

Customers: "A person or organization who has purchased products from us in the current or past three fiscal years. Excludes prospective customers listed in the Prospects table and old customers archived in the Customers table in the SalesArchive database."

Sale: "A temporary purchase price discount offered on selected products (listed in the SaleProducts table) during the period defined by the SaleStartDate and SaleEndDate attributes."

1.The definition must define the noun, which constitutes one record in the table. image text in transcribed

2. The definition must define the noun, which constitutes one record in the table.

image text in transcribed

3. The definition must define the noun, which constitutes one record in the table.

image text in transcribed

QLQueryl OWNER-PC 1385nXSahLmrfk Owner PCMONner (53) Microsoft SQL Server Mand gement Studio PC.Kvu File Edit View Query Project Debug Tools Window Help Debug SQL Queryl sql CIOwl [dbol Sect PC (SQL Server 1106020 Databases System Databases snapshots EE U CAKS2017D8 Kwu4385nXSahl E Database Diagrams Tables System Tables ileT bo,CECo H dbo CEProvid Results G bo,Instruct Type Created datetme dbo. Professia Section 2017-02-23 22:23 00.270 dbo,Qualifi Column. Type Computed Length Frec Scale Nullable Tim Trail dbo.QualificationTyp bo,Secti 10 no fCECou El Views Section Number Programmability El varchar no Service Broker Hoom Number Storage ldentty Seed increment Not For Repleation Security Report Serv Query executed successfully Ready Collation NULL SQL Latin General CP1 CLAS sal-Latin1 Ganeral CP1 CLAS (m/al OWNER-PC 1.0 SP3) Onne 00:00:00 Cument connection parameters Elapsed time 00 0000292 3/25/2017 838:01 AM & 38:01 AM OWN R-PC (O aps 00:0000-23 & 38:01 AM Connection rows 13 start 3/25/20 838:01 AM OWNER-PC Server version Session T Col16 Ch 16 8:58 AM