asked
Requirements (Table Names, Entities, ERD Diagram, etc.) for Mobile Shop Database please?
Could you tell me table names and entities that should be in **Mobile Shop Database Management System**? Please Help
This site runs off of votes. Please indicate all helpful answers below by clicking on the thumbs up next to them. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
is it just a shop or is it a mobile phone repair center as well? if it's just a shop, a generic model of any shop would do but if it is a repair center you have to build up your database. i'm more than happy to give you advises but i need some initiative from your side... to design a database solution you need to map the processes first... try to create an ERD diagram to start with something and later you can adjust it.
i was a DBA and ERP system support for 2 years (and a repair technician for 3 before that, while i was doing my degree) in a company that used to repair mobile phones (and other electronic devices) for the bigest mobile phone manufacturers like Apple, HTC, Samsung etc... so i have some experience tha may be useful for you
employees- to store employes customers- to store customer orders- to save work order info phone- to save phone date like model info
You probably have more requirements than just the name, right? Walk through the requirements, think about the things that define those requirements as pieces of data and how those pieces of data relate to each other. You should be able to make a pretty good start just walking through that process.
17 People are following this question.
