Foundations of Database Technology †Free Samples to Students

Question: Discuss about the Foundations of Database Technology. Answer: Introduction Australian Premier League is a newly lunched premier soccer leagued in Australia. They want a new database solution for storing their soccer information. Also, they want this database system must be easily accessible. This report is intended to design of a database system for APL. This report includes an entity relationship diagram and the business assumption for this database. Moreover, this report includes the database relational schema. Business rules and assumptions Each club has numerous individuals and individual can turn into an individual from just a single club. On the off chance that need to wind up plainly an individual from another club, then a different part id must be gotten for the new club. The part's close to home data is kept up by the database. The data incorporates part id, first name, last name, address, city, postcode and email address. Clubs offers assortment stock which their image engraved on it. All clubs offer same kind of things yet they change by their logo, shading or example. The database ought to keep up the stock data together with their offering cost and sum sold data. Each club keeps up one stadium in which every one of the recreations played by the club is composed. The stadium data incorporates stadium name, seating limit, aggregate percent participation and number of official suits. The stadiums are not shared among the clubs. A player can play in any of the three divisions and thus the quantity of recreations played by the player in each of the three division are kept up in the database. Relational Schema DIVISION (division_name, detailed description) CLUB (club_id, club_name, club_city, club_state, club_email) SPONSOR (sponsor_id, sponsor_name, sponsor_email, sponsorship_type, funding_amount) CLUB_SPONSORS (club_id, sponsor_id) STADIUM (stadium_id, club_id, stadium_name, stadium_seating_capcity, stadium_cum_percent_attend, stadium_no_of_execuitive_suits) COACH (coach_id, club_id, head_coch_id, division_name, coach_first_name,coach_last_name, no_of_games_coched) MERCHANDISE_ITEM (item_id, club_id, item_name, item_type, item_selling_price, item_amount_sold) MEMBER (member_id, club_id, member_first_name, member_last_name, member_address, member_city, member_postcode, member_email_address) PLAYER (player_id, club_id, player_first_name,player_last_name, player_dob, no_of_games_played, player_current_salary ) FIELD_PLAYER (player_id, no_of_shots_on_target, no_of_assists, no_of_passes, no_of_tackles, no_of_penalties,field_type) GOAL_KEEPER (player_id, no_of_free_kicks_saved, no_of_goal_kicks, no_of_normal_saves, no_of_goal_conceded) PLAYER_GAME_HISTORY (player_id, division_name, no_of_played_games) Bibliography Cagiltay, N. E., Tokdemir, G., Kilic, O., Topalli, D. (2013). Performing and analyzing non-formal inspections of entity relationship diagram (ERD).Journal of Systems and Software,86(8), 2184-2195. Embley, D. W., Thalheim, B. (2014).Handbook of Conceptual Modeling. Springer. Kadivar, M. (2015).Entity relationship diagram approach to defining cyber-attacks(Doctoral dissertation, Carleton University). Kapfhammer, G. M., McMinn, P., Wright, C. J. (2013, March). Search-based testing of relational schema integrity constraints across multiple database management systems. InSoftware Testing, Verification and Validation (ICST), 2013 IEEE Sixth International Conference on(pp. 31-40). IEEE. Mcminn, P., Wright, C. J., Kapfhammer, G. M. (2015). The effectiveness of test coverage criteria for relational database schema integrity constraints.ACM Transactions on Software Engineering and Methodology (TOSEM),25(1), 8. McMinn, P., Wright, C. J., Kinneer, C., McCurdy, C. J., Camara, M., Kapfhammer, G. M. (2016, October). SchemaAnalyst: Search-based test data generation for relational database schemas. InSoftware Maintenance and Evolution (ICSME), 2016 IEEE International Conference on(pp. 586-590). IEEE. Pham, M. D., Passing, L., Erling, O., Boncz, P. (2015, May). Deriving an emergent relational schema from rdf data. InProceedings of the 24th International Conference on World Wide Web(pp. 864-874). ACM. Thalheim, B. (2013).Entity-relationship modeling: foundations of database technology. Springer Science Business Media. Weber, J. H., Cleve, A., Meurice, L., Ruiz, F. J. B. (2014, September). Managing technical debt in database schemas of critical software. InManaging Technical Debt (MTD), 2014 Sixth International Workshop on(pp. 43-46). IEEE.