Apps manager game NEED HELP :)

[iggy23]

So guys...

I would like to create a manager game... Basketball manager

Should i put data in a sql database or..?

 

[Deleted User]

Yes a database is the way to store complex persistent data in most apps. The database used in Android applications is SQLite

https://www.tutorialspoint.com/sqlite/

 

[iggy23]

There is one thing that i doesn´t understand...
How do i make the a team play vs another team, from a sql database????

Which things are being used for making manager/simulator games?

 

[Deleted User]

Your question is extremely broad. There are a lot of things to think about.
One of the first things you need to do is design the database schema. I usually start with this because the data that your app needs is pretty crucial to the overall design.
Ask yourself the following questions:-

- What information is associated with a team?
- What information do I need to store for results?

So thinking about the team, it has many players associated with it. And teams play each other in a fixture, from which there's a result. And presumably there's also a league table. So already we've identified several objects within the system that you need to record, i.e:

- teams
- players
- results
- leagues

So each of these items may have a database table to record the information. I'm not saying the above is going to be the correct way of doing things, but just trying to explain the analysis you need to do before starting to implement your app.
Additionally, these tables also have associations, or relations between each other.

Database design is a huge aspect of software design, and you need to become familiar with the concepts before embarking on this project. I strongly recommend taking time to study this. Data underpins nearly all software systems.

 

[iggy23]

OK, you´re right

What about fx. is it possibel to make different leagues in different databases, and make all leagues run together?

Like if you choose to a spanish team, but you still can see how it is going in greek league etc....

 

[Deleted User]

Well there's nothing stopping your database from having league tables for different countries. You could even get them to compete against each other, like in the football Champions League.

 

[iggy23]

Ok, thanks for help

 

[iggy23]

I will create team database...

but problem is that i don´t understand how this works ( the thing on the picture )

someone who understands better than me ?

 

[Deleted User]

Looks like you're trying to create a table called TEAMS.
Any database table needs at least one column in it, to be of any use at all. In that dialog window you have open, you need to type something in the 'Column name' box. You also have to select a Data type.
But really, you need to read through a database beginners guide. Otherwise you're going to struggle with this.

 

[iggy23]

So now i have created a database with players and teams....NOT finished yet, but still...

im thinking about finances table, so how to connect the finances table with teams and players?

 

[Deleted User]

It depends what's in the finances table. If it's related to the teams or players table, then you need a foreign key constraint to make an association

https://www.w3schools.com/sql/sql_foreignkey.asp

 

[iggy23]

Hi again

Should i do the same, if i would like connect players to the team?

Like player1 needs to go to team1.......

Now player1 is in one table and team 1 is in another table

 

[Deleted User]

Hi again

Should i do the same, if i would like connect players to the team?

Like player1 needs to go to team1.......

Now player1 is in one table and team 1 is in another table

Yes. To keep it simple, let's assume that a player can only be in one team. A team has multiple players.
So you have two database tables - Teams and Players.
In database terms, this is a typical many-to-one relationship.
So in the Player table, you would have a foreign key reference to the Team table, not the other way around.

 

[iggy23]

ok thank you

what about trades? or automatical signings of players?

 

[iggy23]

is it good ??

Foreign key name : PlayerToTeam
Referenced table : Database1 . TeamBaseWorld
Column : idPlayerDatabase
Referenced Column : idTeamBase

if its ok, then my players are on the right teams now???????

 

[Deleted User]

So if the above means that you have a foreign key constraint where

PlayerTable.TeamId -> TeamTable.Id

then that's ok.

Btw you do realise that Android doesn't use MySql as a database? You'll need to use SQLite.

 

[iggy23]

in player table i have made a column where i wrote team id

and in my foreign key i wrote :

 

[iggy23]

can i use SQLite studio then? i think its same as sqlite

 

[Deleted User]

Looks good. The only thing I would suggest is to remove the PlayerTeam column from your Player table. This information will already be in your Team table, and so you're duplicating it. Duplication is something you want to avoid in database design. It's part of a process called 'normalisation'.

Yes you can use SQLite studio to design your database schema.

 

[iggy23]

Ok. Now i have database with players, teams...

I will make a table with coaches and finances also.

What about sponsors ?
How to add them?

Player development?
Or decreasing?

What is next?

 

[iggy23]

someone answer

 

[Deleted User]

someone answer

Sorry but the questions you ask are too vague. Technical Q&A forums like this work best with focused problems. And unfortunately app design in this context, although possible at a high level, becomes impractical if you want to dive into the finer details. At this point it's down to you to think more about what you want your app to do.
To develop this app further you need to think about the following:-

- Developing the database schema further
- Designing the UI. Think about the workflows, and how the user navigates between screens
- Deciding what the main game elements are - challenges, aims etc.
- If there are any graphical elements involved

All this before you start to write the code which implements your game.

 

[iggy23]

OK, i will start to make UI and she how it goes

Im thinking to add a feature :
skipping24 sec, 2min, 5 min,10 min,20 min, and whole game button

you know... like if you dont want to watch the game, then you can click on "skip" and choose 24 sec, 2 min etc...

 

[iggy23]

so that is how my menu should look like at the beginning

in the game i have 24 teams now... to that means that after 48 games the playoff round starts

16 teams go to playoffs : playing 32 games
then 8 : playing till 3 wins
then final 4 playing best of 7


there should be thes gamemodes :


custom teams ( when you choose a team, the players are randomly placed i different teams

franchise : you choose a team, and try to win champinships with it...

View Rosters : osibility to check rosters without choosing a team.


SO MAYBE SOMEONE KNOWS WHAT I NEED TO DO AS MY NEXT STEP?

 

[iggy23]

someone give me some advices again