Field Name Description Data Type Field Length Name Name of Track Text 33 Time Du
ID: 3820943 • Letter: F
Question
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
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
definition of a Relational Database Table, Examine into and oft of Desie DED oc a spreadsheet to create a data dictionary to describe each indivilial create a spreadsheet with the following headings describe the fidiar fields into Name, Description, Data Type, Field Length. As you pur A daaibee spreadsheet, see you can organize them ty teoord a collection of related record types tables) Summarize teadlataan benvam the renora types you identifiod by drawing a siatchsimilar to ERD the university environment shown in the Unit6Ngues Dataiuwe sample spreadsheet describing song trackses a CD Sorg Track isamaand Data Type Description Field Name Name of Frick Name Duration in seconds Number Time Track Perform Artist kind of music Tea Genre Deliverables for Milestone 2 An algorithm for one process of the Design DFD A spreadsheet listing cach data feld found the sciecund Design INFD ina A sketch showing the relationships berween identified tecand typesExplanation / Answer
Please provide the data flow diagram(dfd) which is being reffered to here.
Data dictionary can created with the data provided in DFD and after that ERD can be created.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.