Xxdsfsdfsd

Entity Name | Attribute Name | Attribute Description | Attribute Datatype | Attribute Nullability | Attribute Default | Attribute Domain | Attribute Key |

User | userId | This attribute uniquely identifies the entity type user | integer | required | n/a | 10 | Primary Key |

User | email | This attribute stores a value for the email address of each user. | Text – variable length | required | n/a | 20 | Alternate Key |

User | password | This attribute provides the user with access to the system. | Text- variable length | required | n/a | 15 | Alternate Key |

User | userType | This attribute is the subclass discriminator | Text- Fixed length | required | Registrant | 11 | Alternate Key |

Registrant | RegistrantID | This attribute uniquely identifies the registrant. | Text- variable length | required | n/a | 10 | Primary Key |

Entity Name | Attribute Name | Attribute Description | Attribute Datatype | Attribute Nullability | Attribute Default | Attribute Domain | Attribute Key |

creditcard | cardNumber | This attribute uniquely identifies the creditcard | integer | | n/a | 12 | Primary Key |

creditcard | RegistrantID | This attribute uniquely identifies the Registrant | Text – variable length | | n/a | 10 | Foreign Key |

creditcard | cardType | This attribute stores which type of card is being used. | Text- variable length | | n/a | 10 | N/A |

creditcard | cardProvider | This attribute identifies the company which the card belongs to. | Text- Fixed length | | n/a | 15 | N/A |

Creditcard | expirydate | This attribute provides the expiry date of the credit card | Text- variable length | | n/a | 4 | N/A |

creditcard | deleted | This attribute stores old cards which have been deleted | integer | | n/a | 12 | N/A |

creditcard | preferredCard | This attribute stores the preferred card of the user | Text- variable length | | n/a | 12 | N/A |

Entity Name | Attribute Name | Attribute Description | Attribute Datatype | Attribute Nullability |...