Skip to main content
  1. Create a database which is having two tables in it, Account and Contact
    1. Accounts have fields: Id, Name, city, state.
      1. Id is the primary key and other fields are text fields.
    2. Contacts have fields: Id, FirstName, LastName, Email, Phone, AccountId.
      1. Id is the Primary key.
      2. AccountId is the foreignkey to Account Table.
      3. Other field are text fields
  2. Design an UI that will show all account information in a table. This table will name, city and State of the account Record.
  3. Once a user clicks on the Account Name, then it will show all the contact details in a separate table whose accountId is equals to the Account Record's Id.
2 件の回答
0/9000