yourdon symbols This is a topic that many people are looking for. bluevelvetrestaurant.com is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, bluevelvetrestaurant.com would like to introduce to you Video Store Database: Dataflow Diagram (1 of 2) – YouTube. Following along are instructions in the video below:
“Out loud. So this is what i m looking at okay section. B. This is is the first extended response.
So just in case. You have um. If you re me. And you do an exam and the second you leave the exam hall.
All the stuff in your brain. Just just goes. I kinda. I don t remember any of it um let me rehearse.
The question for you so. That you can remember. What is about there s a databases question to begin with a small video store records. Details of its customers and the videos and dvds.
They ve borrowed using v store. A software application. Which is connected to a database the store has a single personal computer attached to a cash drawer barcode scanner and printer. The owner of the store uses the computer degenerate various financial institute s from the database.
The sales staff use the computer. When enrolling new members processing sales and entering return movies. The customer is provided with a membership card that includes a barcode representing their membership number similarly each video dvd has a sticker with a unique barcode and a separate f. Possible sheet is used to process all non cash payments the following incomplete data.
Flow diagram is an attempt to describe the information system so copy the diagram above and complete it by adding some labeled data flows okay so before we get tucked in that just delivers what was i trying to do i was trying to we did really badly on the time flow diagram on the previous exam. Right so i wanted to bring this up straight away. But i wanted to give you a little bit of a hand because it is the first question out of the whole extended response. So how do i put it.
Later. I might have just said okay. We ll work it out like i did before. But this is me kind of giving you a bit of a leg up and saying look.
Here are the pieces that i want you to feel. It i just want you to give me the connections. Okay so the first thing to notice is well okay one two three four these are the processes and you can see they correspond to what was mentioned in the sort of a prologue right so you want to figure out each process. I think they re kind of like the core of the diagram and then all the rest of it it s a little okay.
How does how do they relate to each the process. Okay now in many cases. The process of kind of stuck off on their own and isolated and they don t relate to the other processes. But other times they do okay so for instance.
That s how to think about enrolling new members enrolling. New members who does the enrollment of new members think back to the question. Who s the actual person who initiates that process then remember. It s a sales staff right and they re all the way down.
Here. Okay now i could have been sneaky and just giving you these icons logos right. I put them in no order okay. But i actually gave you the the way that they re arranged is actually kind of a hit okay because they re arranged in a way.
That is probably the most logical and less less data flows over flapping and that kind of thing. Okay so the sales staff. Even though they re the people who are actually initiating this process and making it happen okay think about what data they provide to that process. What data do they provide that process.
Think carefully what data originates from the sales staff and goes to the process have a think customer d does have to get entered in right. I assume you know the sales staff lords type you do. But that kind of tells you something right away that data actually doesn t come from the sale staff rate. It doesn t originate from them they might actually be entering it in they might be the participant at that point.
But they re not the source of the data. And that s what data flow diagrams are about okay so customer details is right. But they come from surprise surprise. The customers okay so here s my first data flow that i m going to put it customers they re going to provide information to the enrollee member process.
Okay good morning. Now you could say just customer details. But kill me a little more specific what else would we put there. I think i need probably other markets.
If itif you said customer details. But what else could we put in that more specifically some basic stuff. What else might they give say that again yeah. Godhead did it so things like the dress maybe probably a further.
But would do as well cool all right like i said. I think custom idioms would get you the mark anyway. But um. It s a it s good to be as specific as possible wherever you can and that s not that hard to think of right okay.
That s the same way as data gets provided from the customers to this process. The process sense of data back to the customer right think back to the question. What do you get out of this process. What does the customer receive after they enroll and think.
It s not an object even though they get an object. This is just data flow diagram. So what data do they get back yeah. That s right good okay.
There s the data. So i m trying to try to tease out right if they don t get a card back. It s sorry take that back they do get a card back. But with regard to the data flow diagram.
I m not interested in what objects they get i m interested in the data. They receive okay let s keep going now. The enrollment of the new member right that process it doesn t just get data for the customer then send it back it has to interact with this v. Store.
This program. Which this shop has right so it s not just between the customer. And this process. Where would it go where would it send some data to any suggestions let me ask you this bless you we re the new members enrolled right do you think that data goes straight to the generation of a report.
Which the owners going to have and then go through and all that kind of food do you think that would happen to me dearly. But probably not the way. Why why don t you think i mean the owner is going to want reports that include member data right. But why wouldn t it just go straight.
There what you re jack okay store it for later use why anyone help me out or jack. The only idea. Why would they why would they do that in case. You need the member for later right.
I m trying to get a tour. How busy might this shop be actually we don t really know right. But assuming that they get quite a few members right and then raleigh members constantly doesn t really make sense to generate a report every single time. A new member is enroll right.
Which is why you would store the data for a later time so where would we store it not that many places to store it right in this case. Actually you ve only got one database in the whole system. So this is where it s going. Yeah okay.
It s going to go into that central database. What kind of things would you put their work. I m post that to you what kinds of things are going to go from this process and get stored long term in that central database. What do you think any takers.
What do you think drivers yeah good um everything that was input and output from this process. It s all going to get started here right because not much you say taking this data and passing it in and you ve got the name the address the phone number. But when that customer comes back with their card and they swipe it or it gets scanned or whatever you re like who are you i don t know who you are because i don t know who that number first right and vice versa. If you just stored.
The member number and then they start their cars like we re great i recognize you as someone who has a membership here. But i don t know anything about you okay so we would put my suppose the member details and there are little bit number or their id number ought to be a little more concise. Okay let s start moving over to the right. We re talking about these reports right now.
This is a really easy bit you can be as detailed as you want. But all i was looking for is this generation of a report. Okay being that it has to go through to a database. What kinds of ways do we know to get data out of a database.
We learned a whole we ve spent a few lessons on it it s like a sophisticated language of its own what would you use yeah you need to query right um. You don t just go out to the database. And you know ask your questions. Like syria you ve got to put it in a structured form.
So. A query is what gets passed from this process to the database. Okay does that make sense what gets returned you can say in report data or records. Either that would be fine.
It s a bit difficult to be more specific than that because it depends on what kind of report. The owner ones right so i think you sort of have to be intentionally vague there okay right we re doing pretty well. We ve sort of got two processes covered okay. So let s move it down a little bit ” .
Thank you for watching all the articles on the topic Video Store Database: Dataflow Diagram (1 of 2) – YouTube. All shares of bluevelvetrestaurant.com are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
Watch part 2 of this video: https://www.youtube.com/watch?v=QkKTxsMBdZs
Data Flow Diagram, Data Store (Software Genre), Database (Software Genre)