Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Field Name Description Data Type Field Length Name Name of Track Text 33 Time Duration in Seconds Number 3 digit number Artist Track Performer Text

Field Name

Description

Data Type

Field Length

Name

Name of Track

Text

33

Time

Duration in Seconds

Number

3 digit number

Artist

Track Performer

Text

40

CD

CD w/song tracks

Text

35

Genre

Kind of music

Text

15

For one process of your Design DFD, create an algorithm that expresses the processing logic. You may use either pseudocode or flowcharting.

Examine the data flows into and out of two data stores of your Design DFD. Use a spreadsheet to create a data dictionary to describe each individual data field. Create a spreadsheet with the following headings to describe the data fields: Field Name, Description, Data Type, Field Length. As you put fields into the spreadsheet, see if you can organize them by record type. A relational database is a collection of related record types (tables). Summarize the relationships between the record types you identified by drawing a sketch similar to the ERD of the university environment shown in the Unit 6 Notes: Intro to Database. Here is a sample spreadsheet describing song tracks on a CD. Song Track is a record type

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions

Question

Describe the menstrual cycle in a woman.

Answered: 1 week ago

Question

Explain methods of metal extraction with examples.

Answered: 1 week ago

Question

=+ Who is the negotiation partner at company level?

Answered: 1 week ago

Question

=+Which associations exist?

Answered: 1 week ago