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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started