CREATE DATABASE HorseRacingDB; USE HorseRacingDB; CREATE TABLE ( HorseID INT NOT NULL…
- User
CREATE DATABASE HorseRacingDB;
USE HorseRacingDB;
CREATE TABLE ( HorseID INT NOT NULL AUTO_INCREMENT, HorseName VARCHAR(100), Age INT, GenderENUM(“Male”, “Female”), Breed VARCHAR(50), OwnerID INT, PRIMARY KEY (Horse ID), FOREIGN KEY (OwnerID) REFERENCES Owners (OwnerID) );
CREATE TABLE Owners ( OwnerID INT NOT NULL AUTO_INCREMENT, OwnerName VARCHAR(100), ContactNumber VARCHAR(10), PRIMARY KEY (OwnerID) );
CREATE TABLE Jockeys ( JockeyID INT NOT NULL AUTO_INCREMENT, JockeyName VARCHAR(100), Rating DECIMAL(3,1), PRIMARY KEY (JockeyID) );
CREATE TABLE Races ( RaceID INT NOT NULL AUTO_INCREMENT, RaceDate DATE, RaceName VARCHAR(100), Location VARCHAR(100), PRIMARY KEY (Race ID) );
CREATE TABLE ( ResultID INT NOT NULL AUTO_INCREMENT, RaceID INT, Position ENUM(“I”, “II”, “III”), JockeyID INT, Horse ID INT, CompletionTime TIME, PRIMARY-KEY(ResultID), FOREIGN KEY (RaceID) REFERENCES Races (RaceID), FOREIGN KEY (JockeyID) REFERENCES Jockeys (JockeyID), FOREIGN KEY (HorseID) REFERENCES Horses (HorseID) ); write C# code to enter/edit data
- Assistant
Sure, here is an example of how you can write C# code to enter/edit data in the HorseRacingDB database:
First, make sure to import the necessary namespaces:
using MySql.Data.MySqlClient; using System; // Assuming you have established a connection to the database // Enter data into the Horses table string horseName = "Secretariat"; int age = 7; string gender = "Male"; string breed = "Thoroughbred"; int ownerID = 1; string insertHorseQuery = "INSERT INTO Horses (HorseName, Age, Gender, Breed, OwnerID) VALUES (@HorseName, @Age, @Gender, @Breed, @OwnerID)"; using (MySqlCommand command = new MySqlCommand(insertHorseQuery, connection)) { command.Parameters.AddWithValue("@HorseName", horseName); command.Parameters.AddWithValue("@Age", age); command.Parameters.AddWithValue("@Gender", gender); command.Parameters.AddWithValue("@Breed", breed); command.Parameters.AddWithValue("@OwnerID", ownerID); command.ExecuteNonQuery(); } // Edit data in the Owners table int ownerID = 1; string ownerName = "John Doe"; string contactNumber = "1234567890"; string updateOwnerQuery = "UPDATE Owners SET OwnerName = @OwnerName, ContactNumber = @ContactNumber WHERE OwnerID = @OwnerID"; using (MySqlCommand command = new MySqlCommand(updateOwnerQuery, connection)) { command.Parameters.AddWithValue("@OwnerName", ownerName); command.Parameters.AddWithValue("@ContactNumber", contactNumber); command.Parameters.AddWithValue("@OwnerID", ownerID); command.ExecuteNonQuery(); } // Similar approach can be used to enter/edit data in other tables (Jockeys, Races, and Results)Note: In the code above,
connectionrepresents an established MySqlConnection object for connecting to the HorseRacingDB database. Make sure to replace any necessary connection strings and update the table names/field names according to your database schema.