question

Thadan avatar image
Thadan 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
homeworkdatabase-diagramsentitydatabase-name
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Are you asking us to design your database?
2 Likes 2 ·
true,i've an assignment to design mobile shop database system. could you help me with some advises please
0 Likes 0 ·
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.
0 Likes 0 ·
emil87b avatar image
emil87b answered
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.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks you, I'm forget to tell it's Mobile Sales and Services, so there will be also repair center, I've started en ERD with some entity like Customer, Staffs, Sales, Phone :D
0 Likes 0 ·
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
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
Maybe something here could act as a starting point http://www.databaseanswers.org/data_models/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

neeehar avatar image
neeehar answered
employees- to store employes customers- to store customer orders- to save work order info phone- to save phone date like model info
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.