I am new to Oracle 10g xe. When I log into hr account, how do I start creating new database and insert values? My case study is a five aside football league, where the organizer wants to know following questions:
- alphabetical list of all the teams and their players.
- how many time players have been awarded player of the match?
- list different types of penalty points which can be awarded?
- produce a list of all teams playing all other teams indicating who is at home and who is away.
and lot more.
How do I start creating a new database from scratch?